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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I count the number of times a particular charcter ("." say) (https://www.excelbanter.com/excel-discussion-misc-queries/16989-how-do-i-count-number-times-particular-charcter-%22-%22-say.html)

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

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" 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?

wat

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

"Bob Phillips" wrote:

=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?

All times are GMT +1. The time now is 03:26 AM.