Counting instances in a cell

  • Thread starter Thread starter jose
  • Start date Start date
J

jose

Hello,

How can I count the number of times the number 4 repeats
itself in a single cell? Example: I have 456444 in A1
and I would like to know how many time the number 4
appears in the cell. Any help would be appreciated.

Thanks,

Jose R.
 
Below assumes that A1 containing 456444 is text.

In B1 enter:
=(LEN(A1)-LEN(SUBSTITUTE(A1,"4","")))

HTH
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
Count specific characters in a cell 7
Counting number of times a specific word appears in a single cell 19
Count entry only once across multiple worksheets? 4
HOW TO COUNT INSIDE A CELL 5
count until blank cell 2
COUNT function - # of occurences a number appears in all cells 26
Help with Count formula 2

Back
Top