Hi I have a bit of a problem. I have a list of IDs i would like to
extract from a column of cells in excel. The problem is they are not
fixed length or all numeric, etc. For example,

71420164
7115-0003
7115-0011
713005L
713005R

In addition there are 250 of these. To make matters more complicated,
the cells which contain the IDs are also random length and made up of
alphanumerics. For example,

"SCORPIO FEM COMPONENT SZ 5L REF: 71-3005L LOT:ET05V03 SCORPIO TIB.
TRAY SZ 3 REF: 7115-0003
LOT: 4EHMCA SCORPIO TIB INSERT 3/12MM REF: 72-13-0312 LOT: 16124501"

or

"Genesis 2 Non Porous Tibial Baseplate Sz 3 Ref: 71420164 Lot:
06BT95572 Genesis 2 Biconvex Patellar Sz 23mm Ref: 71420566 Lot:
05MM06587 Genesis 2 Cruciate Retaining Femoral Component Sz 4 Ref:
71420006
Lot: 06BM16921 Genesis 2 Cruciate Retaining Poly "

or

"13 FEM COMPONENT SCORPIO REF 71-3013L LOT 10045776MU 11 TIB BASE
REF 7115-0011 LOT Y1EMA000MAC 11/13 TIB INSERT REF 72-13-1110 LOT
10228737CM 11 PATELLA REF 73-0110 LOT G314FLAA713"

Is there a way i can get excel to lookup one of the IDs from a column,
search the alphanumeric cells and extract it to an adjacent column.
This is driving me crazy!

Thanks