Returns the length of a string.
Sample Usage
LEN(A2)
LEN("lorem ipsum")
Syntax
LEN(text)
text
- The string whose length will be returned.
Notes
LEN
counts all characters, even spaces and nonprinting characters. In cases whereLEN
returns unexpected values, ensure that there are no such characters intext
.
See Also
LEFT
: Returns a substring from the beginning of a specified string.
RIGHT
: Returns a substring from the end of a specified string.
MID
: Returns a segment of a string.