Hi
one way:
len(your_str)-len(replace(your_str," ",""))

--
Regards
Frank Kabel
Frankfurt, Germany
"xnman" schrieb im Newsbeitrag
...
In VBA, I know there is a simple way of counting blanks in a string,
but
I can't remember it. Anyone know how to do this?

thanks
xnman