Quick, clean, and to the point

Excel LEN Function

Excel LEN function


Get the length of text.
Return value 
Number of characters
=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.
  • Number formatting is not included. (i.e. the length of "100" formatted as "$100.00" is still 3).

Excel Formula Training
