Difference between revisions of "Documentation/How Tos/Calc: LEN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
Line 3: | Line 3: | ||
== LEN == | == LEN == | ||
Returns the length of a text string. | Returns the length of a text string. | ||
− | |||
=== Syntax: === | === Syntax: === | ||
<tt>'''LEN(text)'''</tt> | <tt>'''LEN(text)'''</tt> | ||
: returns the number of characters in the text <tt>'''text'''</tt>, including spaces. | : returns the number of characters in the text <tt>'''text'''</tt>, including spaces. | ||
− | |||
=== Example: === | === Example: === | ||
Line 15: | Line 13: | ||
<tt>'''LEN(123.4)'''</tt> | <tt>'''LEN(123.4)'''</tt> | ||
− | : returns <tt>'''5'''</tt> (numbers are converted to text) | + | : returns <tt>'''5'''</tt> (numbers are converted to text). |
=== See also: === | === See also: === |
Revision as of 08:13, 30 December 2007
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).