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