LEN
Information Functions
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:
- directly
- as a text string returned from another formula
- as a reference to a cell containing a text string
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:
|
Results:
|