Hi Forum,

I feel this should be a simple task. I have in mixed text and numerals in column c2:c6 i.e A1 B6 k7 T8 z2 y4

what I want is to see a total in c7 of 1+6+7+8+2+4=28

I want the to addition of the numbers but ignoring the single text prefixes.

Any Suggestions?

Thanks in advance

Maxim