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) |