To count the total characters (including spaces) in cell A1:
=len(A1)
To count the total characters (not including spaces) in cell A1:
=LEN(SUBSTITUTE(A1," ",""))
To count the total specific characters in Cell A1, for instance the number of times the letter “d” appears in cell A1:
=LEN(A1)-LEN(SUBSTITUTE(A1,"d",""))
December 8th, 2008 at 7:28 am
Why am i unable to use the formula
=LEN(SUBSTITUTE(A1,” “,”"))
even if there are characters in A1?
December 9th, 2008 at 7:46 pm
@fathima
Paste that back into excel but replace the quotes. Just delete them and press shift + ‘ on your keyboard. The first three quotes are characters that excel does not recognize.