Counting Question

[TrentA]

I have the following formula in a cell

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

This is for counting data such as:

1,2,3,4

If I just want to count the numbers (and not the commas) it works
fine. But I would like to drag this down and count an entire column
but in some of the cells I have data such as:

1,2*,3,4,5**,6,7*,8

Again I just want to count the numbers, not the commas or the
asteriks.

Thanks

 

[JE McGimpsey]

one way:

=LEN(SUBSTITUTE(SUBSTITUTE(A1,",",""),"*",""))

 

[RagDyer]

What return would you expect from:

10,20**,30*,40
?

 

[TrentA]

Thank you

one way:

=LEN(SUBSTITUTE(SUBSTITUTE(A1,",",""),"*",""))