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

--
AndyU
-----------------------------------------------------------------------
AndyUK's Profile: http://www.excelforum.com/member.php...fo&userid=1634
View this thread: http://www.excelforum.com/showthread.php?threadid=27735