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

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.

Result