Documentation/How Tos/Calc: LEN function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 07:27, 30 December 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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:

LEFT, RIGHT, MID

Text functions

Personal tools