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

1test string=LEN( A1 )
2test string 2=LEN( A2 )
3 =LEN( A3 )
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.

The Microsoft Office website also provides a description of the Excel LenB function, which is supported by languages that use the double-byte character set (e.g. Chinese, Japanese, Korean).