LEN
Formula Explanation
LEN returns the number of characters in a text string.
Formula Syntax
Result column input: LEN(text / column number)
The LEN function syntax has the following arguments:
- text (required): The text for which you want the length. Spaces are counted as characters.
Usage Example
Calculate the length of the strings in column DE2 and write the result in column DE3.
DE3 = len(DE2)
Spaces are counted as characters.