Letter Counting Function
 

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


--
bctrophy
------------------------------------------------------------------------
bctrophy's Profile: http://www.excelforum.com/member.php...o&userid=29830
View this thread: http://www.excelforum.com/showthread...hreadid=495350

Letter Counting Function
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=495350

Letter Counting Function
 

Ron,

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


--
bctrophy
------------------------------------------------------------------------
bctrophy's Profile: http://www.excelforum.com/member.php...o&userid=29830
View this thread: http://www.excelforum.com/showthread...hreadid=495350