LEN Function in Excel – find Length of the string in Excel

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

LEN Function in Excel 1

Row number 2 to 5 returns the length of the strings.
Row number 6 returns the length of empty string which is 0.

Result

LEN Function in Excel 2