Excel Formula to count Numbers

Hi,

I want to write a formula in excel so that i can get the count of numbers from given below values-

Tech243214434Tech324234#$% the asnwer should be 15.

Mate6576576Mate6768## the asnwer should be 11.

Dev2347Dev234243#$$ the asnwer should be 10.


Thanks,

  Devbrat Tripathi

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

  Vikas       19 Aug 2019       1       0     

SUMPRODUCT(ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1))*1)

  Vikas       19 Aug 2019       1       0     

SUMPRODUCT(ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1))*1)

  Vikas       19 Aug 2019       1       0     

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

  Vikas       19 Aug 2019       1       0     

  Vikas       19 Aug 2019       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any