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

In the spreadsheet below, the Len function is 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).