The Excel LEN Function
Basic DescriptionThe Excel LEN function returns the length of a supplied text string. The format of the function is :
LEN( text )
where the text argument is the string that you want to find the length of. This can be supplied to the Len function either:
Len Function ExamplesThe examples in the spreadsheet below show the Len function used to return the length of three different text strings (one of which is empty). The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Note that, in the example in cell A2 & B2 of the above spreadsheet, there are 3 spaces between the words "Test" and "String", which have all been counted as characters by the len function. Further information and examples of the Excel Len function are provided on the Microsoft Office website. |
|||||
|
|
|||||
Copyright © 2008-2010 ExcelFunctions.net |