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

previous-small LEN Function in Excel                                                                                                                 next_small LEN Function in Excel