You guys are awesome. This works great for extracting part numbers off a
database export list that has the part number with the description all
together cells. You just cut my time for this task by 95%!!

I wish there was a preset function on excel, though.

Thanks!

"Bob Phillips" wrote:

Regardless of position

=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"
0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scoops" wrote in message
oups.com...
Hi Thomas

If your data is fixed at aaannn then you can use:

=RIGHT(A1,3)

Regards

Steve