Difference between revisions of "Documentation/How Tos/Calc: LEN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 15: | Line 15: | ||
: returns <tt>'''5'''</tt> (numbers are converted to text). | : returns <tt>'''5'''</tt> (numbers are converted to text). | ||
| − | + | {{Documentation/SeeAlso| | |
| − | + | * [[Documentation/How_Tos/Calc: LEFT function|LEFT]] | |
| − | + | * [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]] | |
| − | + | * [[Documentation/How_Tos/Calc: MID function|MID]]''' | |
| − | + | * [[Documentation/How_Tos/Calc: Text functions|Text functions]]''' | |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 14:01, 25 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).
