I am no expert with excel so any help is appreciated!
I am trying to make one cell do multiple searches within another.
I know that to search one cell for a specific word you would use
But I need to find multiple different words in one cell. Heres an example of what im trying to do:
I need to show all the allergens in the ingredients cell eg peanuts, gluten, milk, sesame seeds etc
How do I get the result to list all the allergens?
I know that I can do a single find function in separate cells and then concatenate them, but there must be a more simple way?