=SUMPRODUCT(--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))


"LiAD" wrote:

I am trying to get a formula that will count the number of numbers within a
text string.

Example

320,J,KLY - i would like the function to return 3
,32,T,J,KLYU - I would like the function to return 2
1234,h,KlY - i am looking for 4

Anyone know if this is possible?

Thanks