I am using Excel 2003. I have a spreadsheet with one column and hundreds of
rows of text data (exported from an open ended survey question). I want to
be able to group common responses by searching for key words and then
grouping them together. So if column A has "all data." Column "B" may
contain responses containing the word "budget." Column "C" may contain
responses containing the word "HR."

I tried to use the autofilter (custom) function and then cut and paste into
another column, but that didn't work. I also read just about every question
on this string. I am afraid I am not a proficient Excel user.

HELP! If I can just find a way to highlight a particular search, I can cut
and paste myself Thanks for your help!