Excel LEN Function

Basic Description

The Excel LEN function returns the length of a supplied text string.

The syntax of the function is:

LEN( text )

Where the text argument is the text string that you want to find the length of. This can be supplied to the Len function in any of the following ways:


Excel Len Function Examples

The examples in the spreadsheet below show the Len function used to return the length of three different text strings (one of which is empty).

 Formulas:
 AB
1test string=LEN( A1 )
2test string 2=LEN( A2 )
3 =LEN( A3 )
 Results:
 ABC
1test string11 
2test string 213 
3 0 - empty string has length 0

Further information and examples of the Excel Len function are provided on the Microsoft Office website.