Counting letters in a cell

  • Thread starter Thread starter punter
  • Start date Start date
P

punter

I need to know how to count how many letters are in a cell. Example:

A1 contains "Word is cool". That is 10 letters. Does anyone know
formula that would tell me there are 10 letters in that cell?

Thanks.

Eddi
 
Thanks a lot guys. What is OP? I'm still getting it with the spac
breaks being counted (total of 12) which is much better than I had i
before. Does anyone know of a way to count the letters without th
space breaks being included?

Again thanks much for your help. You have saved me a lot of time
 
Hi
OP: Original poster - that is you :-)

For your formula issue. Try
=LEN(SUBSTITUTE(A1," ",""))
 
Hi Punter!

If you just have letters and spaces:

=LEN(SUBSTITUTE(A1," ",""))
Counts the letters only but would count a period.

If you have punctuation .

=LEN(SUBSTITUTE(SUBSTITUTE(A1," ",""),".",""))
Counts letters and not periods

If you have punctuation !

=LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),".",""),"!",""))
Counts letters and not periods or !

And so on...

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Punter!

Always pleased to help. Just note and understand the structure of the
response and you have a general purpose solution for a lot of similar
problems. For example, we had a problem in another group that needed
( ) and - removed from telephone numbers. Same formula, but different
substitutes.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top