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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Carim" wrote in message
oups.com...
Hi,

I cannot get Countif to return the number of periods in cell A1
(formatted as text) : "1.1.1.1"

Thanks for your help

Cheers
Carim