LEN returns the number of characters in a text string.
Syntax
LEN(text)
Text is the text whose length you want to find. Spaces count as characters.
Examples
Col1 |
Formula |
Description (Result) |
---|---|---|
Phoenix, AZ |
=LEN([Col1]) |
Length of the string (11) |
=LEN([Col1]) |
Length of the string (0) |
|
A One |
=LEN([Col1]) |
Length of the string, which includes 5 spaces (9) |