LEN Function in Excel returns the length of a supplied text string.
Syntax of LEN Function in Excel (length function):
LEN(text)
Where,
- text –Text String that you want to find the length of.
Example of LEN Function in Excel (length function):
Formula
- Row number 2 to 5 returns the length of the strings.
- Row number 6 returns the length of empty string which is 0.