How to move highlighted cell to a new column

[elaine216]

I got a huge database of fruit related terms such as :

apple
apple pie
apple ipod
apple computer
banana milkshake
kiwi
kiwi map
kiwi maple syrup
orange juice
orange mobile

.... etc.

I want to filter out all the non edibles such as ipod, computer and
mobile.

I used conditional formatting to highlight all the non-edibles at the
moment, and terms such as ipod, computer, mobile, map and maple syrup
were highlighted.

However the kiwi maple syrup is edible, and i dont want it to be
highlighted. But you cant manually check every cell if you got like
10000 rows (just an example).

Is there a way to copy all the highlighted keywords to a new column so
that it will be easier to check again? or is there a way to just
automatically copy all the cells (with the keyword)to a new column?

Thanks.

 

[Dave Peterson]

Conditional formatting looks pretty, but it doesn't help much when you want to
manipulate the data.

I'd insert another column and use it as an indicator (Y or N)

Then with some sorting/filtering (like Contains IPOD), it might be able to mark
lots of cells at once.

 

[reddymina]

Maybe you can cut your original column into two, meaning,you can insert another two columns and use @find function to separate the name of the fruits and the other words attached to them.

Afterwhich, you create a pivot table to get the list of the attached words. Once you had the list of the words, put "edible" or "non-edible" to the column next to the words. This list of attached words and the column for edible and non-edible will be used as a lookup table.

You can now prepare a formula comparing the attached words from the lookup table.