Count numbers within text

[LiAD]

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

 

[T. Valko]

Try this:

=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("48:57"))),"")))

 

[LiAD]

outstanding, works a treat

thanks a million

Try this:

=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("48:57"))),"")))

 

[Teethless mama]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Rick Rothstein]

Here is a similar version without the volatile function...

=SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1)))

It will work as long as the cell contains less than 1000 characters.