Count numeric characters in a string

[stuartw]

Hi All

I've played with this for a bit now and I think I have to concede....

How do I count the number of numeric characters in a particular cell? Desired results for example:

997345TECH = 6
SAG857832 = 6
TECH413567/554432 = 12

Note I'm not after unique numeric characters just a count of all numeric. I'm fairly close with:
=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},B2)) but it won't count duplicate numbers.

Thanks for any help.
Stu

 

[circledchicken]

Hi,

Maybe something like this using CTRL-SHIFT-ENTER rather than just ENTER as this is an array formula:

=COUNT(
    --MID(
        A1,
        ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),
        1))

 

[Firefly2012]

Hi Stuart

Here's one way:

Excel 2007
	A	B
1	997345TECH	6
2	SAG857832	6
3	TECH413567/554432	12
Sheet2

Cell Formulas
Range	Formula
B1	=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9,0},"")))

 

[1923glad]

use "LIN" and drag

 

[1923glad]

Oops, =LEN

 

[stuartw]

Marvellous - thanks for your help guys - more than one way to skin a cat!