how to remove letters from a cell

dear all,

i have in column A cells with a mix of letters and numbers together in a form like
letters (seperate) then numbers :

TG 342841,TG 441472-RX001023
MS0012146-ML225126
Civ 126019 Cv 3456006

I am looking for an easy way to have only numbers extracted into B,C and D example:

B1 342841
C1 441472
D1 001023

and so on

I appreciate your usual help

regards

R

Here is one way. Format columns as text if you want to preserve leading zeros.

Please Login or Register  to view this content.

Thanks StephenR
I assume this is a module as to be inserted but what formula goes in B

thank you

That's right. Assumes your data are in A1 and down. No formulae, just run the code.

thank you...