LEN
Definition
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.
In order to use the LEN formula, start with your edited Excellentable:
Then type in the LEN formula in the area you would like to display the outcome:
By adding the values you would like to calculate the LEN formula for, Excellentable will generate the outcome: