Difference between revisions of "Documentation/How Tos/Calc: LEN function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
(See also:)
Line 21: Line 21:
  
 
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
 
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 16:05, 13 September 2008


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

Functions listed alphabetically, Functions listed by category

Personal tools