software

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 quot;searchquot; does nothing.

Thanks!

Robert--
bctrophy
------------------------------------------------------------------------
bctrophy's Profile: www.excelforum.com/member.php...oamp;userid=29830
View this thread: www.excelforum.com/showthread...hreadid=495350
Try this...
For text in Cell A1
B1: =LEN(SUBSTITUTE(A1,quot; quot;,quot;quot;))

It replaces spaces with nothing, then counts the length.

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=495350
Ron,

That did it. Works like a charm. Much appreciated!!!!--
bctrophy
------------------------------------------------------------------------
bctrophy's Profile: www.excelforum.com/member.php...oamp;userid=29830
View this thread: www.excelforum.com/showthread...hreadid=495350