Extracting specific data from cells
 

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

Extracting specific data from cells
 

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

"AndyUK" wrote:


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

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

What we are being asked is is there any way to search all entries in
Column F for text 'XXY', and if found, append the XXY plus the 25
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 do
this.

Thanks.


--
AndyUK
------------------------------------------------------------------------
AndyUK's Profile: http://www.excelforum.com/member.php...o&userid=16346
View this thread: http://www.excelforum.com/showthread...hreadid=277357