Extracting specific data from cells

[AndyUK]

I am a complete novice with regard to VB / Excel macros. However I hav
been posed a couple of questions by a colleague. One I have managed t
answer but I don't know if the other is possible.

We have a column (For example Column F) which contains a description o
parts used within the job for each stage of the job (there are a coupl
of thousand rows in the spreadsheet). Some of the descriptions contai
the part number (a constant 3 letter code eg XXY).

What we are being asked is is there any way to search all entries i
Column F for text 'XXY', and if found, append the XXY plus the 2
characters to the right of XXY to a new column.

Is this at all possible ? If so, can you guide be to the code to d
this.

Thanks

 

[Guest]

Hi
try
=IF(ISNUMBER(FIND("XYZ",F1)),MID(F1,FIND("XYZ",F1),28),"")