LEN function

From Apache OpenOffice Wiki
Jump to: navigation, search



LEN

Returns the length of a text string.

Syntax:

LEN(text)

returns the number of characters in the text text, including spaces.

Example:

LEN("red car")

returns 7.

LEN(123.4)

returns 5 (numbers are converted to text).


See Also

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_LEN_function&oldid=260106"
Personal tools