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.

--
Mark