Letter Counting Function

[bctrophy]

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

 

[Ron Coderre]

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

 

[bctrophy]

Ron,

That did it. Works like a charm. Much appreciated!!!!