Documentation/Calc Functions/LEN
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
LEN
Category:
Text
Summary:
Determines the number of characters (including spaces) in a supplied text string.
Syntax:
LEN(Text)
Returns:
Returns a non-negative integer that is the number of characters in the supplied string.
Arguments:
Text is a text string (in quotation marks), a number, or a reference to a cell containing one of those types, whose length in characters is to be determined.
Additional details:
None.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =LEN("Good afternoon") | Here the function returns the length of the string as 14 (single-byte) characters. | 14 |
| =LEN("Ｇｏｏｄ ａｆｔｅｒｎｏｏｎ") | Here the function returns the length of the string as 14 (double-byte) characters. | 14 |
| =LEN(D1) where cell D1 contains the number 12345.67. | Here the function returns 8. | 8 |
| =LEN("12,345.67") | Here the function returns 9. Note that in this case the number is passed as a string - LEN reports an error if the quotation marks are omitted because the number includes a comma digit group separator. | 9 |
| =LEN("") | Here the function returns 0, since the argument is the empty string. | 0 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
LEN