Formulas and Functions

LEN
The LEN function returns the number of characters in a string value.
LEN(source-string)
source-string: Any value.
Notes
The count includes all spaces, numbers, and special characters.
Examples |
---|
=LEN("12345") returns 5. =LEN(" abc def ") returns 9, the sum of the six letters plus the leading, trailing, and separating spaces. |