I am trying to extract more than one word into a cell and then concatenate these words together. For example if I wanted to remove all the allegens from an ingredients list. Ingredients Dates, Cocoa, Almonds, Orange, Milk, Oats Allergens Almonds, Milk, Oats Its fine if it picks out the allergens to separate cells, I can concatenate them afterwards. Is this possible on google sheets?
Solved by I. Q. in 27 mins