Excel LEN Function

Excel LEN Function

Get the length of text.

Return value 
A number representing the lengh of the text.

=LEN (text)

  • text – The text for which to calculate length.

Usage notes 

LEN is a useful when you want to count how many characters there are in some text.

Numbers and dates will also return a length keep in mind that number formatting is not included. (i.e. the length of “100” formatted as “$100.00” is still 3).

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas