Mark, Apart from the other replies turn on the macro recorder and do a
Find from the Excel menu then look at the code, might help.

Mark wrote:
I am using Excel 97, I have a column of data which needs separating I am
wanting to find each cell that contains in part of the cell the word
'investigating' then with each cell found move it to the next column to the
right.

I have tried the instr function but obviously doing something wrong!

Any help would be appreciated.