Documentation/How Tos/Calc: 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).

Template:Documentation/SeeAlso

Personal tools