ExcelBanter - Counting instances in a cell

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

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

- - Counting instances in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/1695-counting-instances-cell.html)

[email protected]

Counting instances in a cell

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.

Peo Sjoblom

One way

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

Regards,

Peo Sjoblom

" wrote:

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.

Jim May

Below assumes that A1 containing 456444 is text.

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

HTH

" wrote in
message ...
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.

All times are GMT +1. The time now is 07:27 PM.