I know Excel has a function for counting letter/characters in a cell,
but I don't want it to count spaces. Any way to accomplish this?
And forgive me if topic exists somewhere on this forum. I wanted to do
a search first, but clicking on "search" does nothing.
Thanks!
Robert

Signature
bctrophy
Ron Coderre - 21 Dec 2005 21:45 GMT
Try this...
For text in Cell A1
B1: =LEN(SUBSTITUTE(A1," ",""))
It replaces spaces with nothing, then counts the length.
Does that help?
Regards,
Ron

Signature
Ron Coderre
bctrophy - 21 Dec 2005 22:36 GMT
Ron,
That did it. Works like a charm. Much appreciated!!!!

Signature
bctrophy