Count a number of characters in a text string in Excel
Return number of Characters of a String


Count a number of characters in a text string.


The Excel LEN function counts a number of characters (letters & symbols) of a given text strings excluding number formatting like $ or % in a digit. For example, LEN(“Excel”) returns “5”.


=LEN (text)


text – The text to find the length.

Return Value

An integer referring the length of a text string.

Key Notes

  • The LEN function is handy to calculate length of text, number, and dates.
  • LEN function return number of characters of a text as it stores, not the way Excel display it. For Example, The LEN function count characters excluding number formatting (i.e. the length of “$100.00” is 3).
  • Also, account for characters after decimals.
LEN function also count wildcard characters with text for example you have “Char*acter” and you put formula =LEN(“Char*acter”) it return 10.
In Excel LEN function also include length of space like here in cell B6 it returns 18 i.e. it count space with string.

Keep Reading Similar Functions:

Finds position of one text value within another Text in Excel


The SEARCH function finds the position of a specified character or sub-string within a text string. I.e., =SEARCH(“ring”,”String”,1) return “3”, “ring” begins at the third character of “String”.

Read More »
Return character position of a text in Excel


The FIND function displays the numerical position of the character in a string. I.e. to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6.

Read More »
Match two text strings if they are exactly same in Excel


The Excel EXACT function display (True or False) after matching two text strings if they are exactly same. Also identifies case-sensitive differences between two text.

Read More »