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

Count periods in a cell
 

=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

Count periods in a cell
 

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

found the answer :

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

Count periods in a cell
 

Hi Bob,

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

Regards

Carim