EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT

HELP ME PLEASE TO EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT LIKE AB1234C, 123 NO, A123B456 ETC

Nick's picture

Remove Non Numeric Characters

EXTRACT NUMERIC FROM A ALPHANUMERIC TEXT

Sir your process is too lenghty and unworkable for my program. I want a simple formula to get this.
Regards
Anil

Nick's picture

you can limit the amount of

you can limit the amount of calculations it does if you know what the non-numeric symbols will be...

for example, if you know that only A and B are in the string, you can use:

=SUBSTITUTE(SUBSTITUTE("A12B3A","A",""),"B","")
=>
123