Count number of "." characters in a string - XL2K3 1

[MeGustaXL]

Dead simple, but can't remember how to do it!
How do I get Excel to return the number of full stops in a string?
Some examples:

1.1.1 = 2

1.1.1.1.1.2.4 = 6

I've tried

=COUNTIF(MID(A2,1,LEN(A2)),".")

but that returns an error.

Any better ideas?

Chris

Someday I'll know what I'm donig...damn!

 

[strongm]

Something like

=LEN(A2)-LEN(SUBSTITUTE(A2,".",""))

 

[MeGustaXL]

Ha Ha! yes, just like that - any ideas how to do it?

Thanks very much =>*

Chris

Someday I'll know what I'm donig...damn!