Extract numbers from a code

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))
 
Back
Top