Count periods in a cell

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Carim" <[email protected]> wrote in message
news:[email protected]...
> 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
>

As usual ... thanks to Tom O ...

found the answer :

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

Hi Bob,

Thanks a lot ... our messages crossed ...

Regards

Carim