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

G

Guest

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

Bob Phillips

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

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mass Changes in Excel using Wild Cards or other 3
Problem with printing 4
Case sensitive filtering 3
find a charcter in string 1
How to auto place start/stop characters in Excel w/barcode fonts? 1
Help Count a Specific Value in a Row 2
Count entry only once across multiple worksheets? 4
HOW TO COUNT INSIDE A CELL 5

Top