Quick, clean, and to the point

Excel LEN Function

Excel LEN function

The Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included.

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).

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.