LENReturns 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 where LEN returns unexpected values, ensure that there are no such characters in text.
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.
Examples