=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"RH" wrote in message
...
How do I count the number of times a particular charcter ("." say) appears
in
a cell.
For example, ABC.1.21.31.2 should retun 4.
Is there a formula?
|