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