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:
  A B
1 test string =LEN( A1 )
2 test string 2 =LEN( A2 )
3   =LEN( A3 )
 Results:
  A B C
1 test string 11  
2 test string 2 13  
3   0  - empty string has length 0

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