Count Spaces In A String

[Josh in Tampa]

anyone know how i can count the number of spaces in a
string?

thanks.

 

[Jim Rech]

=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))

 

[Jim Rech]

Or in VB:

Len(Strg) - Len(Replace(Strg, " ", ""))