Difference between revisions of "Documentation/How Tos/Calc: LEN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 18: | Line 18: | ||
* [[Documentation/How_Tos/Calc: LEFT function|LEFT]] | * [[Documentation/How_Tos/Calc: LEFT function|LEFT]] | ||
* [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]] | * [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]] | ||
| − | * [[Documentation/How_Tos/Calc: MID function|MID]] | + | * [[Documentation/How_Tos/Calc: MID function|MID]] |
| − | * [[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 alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
Revision as of 14:19, 26 February 2009
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).
