How do I count the number of times a particular charcter ("." say)

[RH]

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?

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RH" <RH@discussions.microsoft.com> wrote in message
news:75B61958-5352-436D-94F1-DD3D79AAE485@microsoft.com...
> 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?
>