Hi,

I have 5 different words that can be combined in every which way. I have a list of cells that have these words combined and/or repeated. I want to search a cell to see if it has any, all, or some of the 5 words and spit it back out in a cleaner manner (preferably alphabetically). I've tried an if/isnumber/search formulas and it usually just spits out the first word in the cell rather than scanning the rest of the cell to see if it has additional words in it.

Example:

words: apple, cat, dog, orange, pear

apple,dog,apple,dog,cat > apple, cat, dog
orange,apple,dog > apple, dog, orange
orange,orange > orange
orange,apple,apple,dog,cat,pear,pear > apple, cat, dog, orange, pear
pear,orange > pear, orange
pear,orange,orange,cat > cat, orange, pear