Count Digits

[navneetvyas]

Hi

Is there any formula to count digits in cell value

Like I have value AAGPS5501A in cell A1 and wanted to count only numbers in this value

[Debraj Roy]

Try This!

Please Login or Register  to view this content.

Confirm the formula by Ctrl + Shift + Enter, Not just Enter..

[navneetvyas]

Thanks Debraj

It Works, Thanks for your help

[Ace_XL]

Non-array

=SUMPRODUCT(--(ISNUMBER(MID(A1,ROW(A1:A100),1)*1)))

[Tony Valko]

Here's another one...

Array entered**:

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

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.