View Single Post
  #3   Report Post  
Jim May
 
Posts: n/a
Default

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.