Extract numbers from a code

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
 
T

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))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top