Extract numbers from a code

[Mark]

Is it possible to extract by formula numbers from a code, for example

Code Number
AS12345WQ 12345
F87654321LD 87654321
HN123 123

I want to be able to take just the numbers from the code and place them in
the column next to it

I've tried playing around with Right, Left and Len but the problem i'm
having is there could be any number of letters at the begining or end of the
code

thanks
Mark

 

[Teethless mama]

=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))