Search Cell for Multiple Text Strings, Return each found value

Excelling Posts 1 Registration date Wednesday May 25, 2016 Status Member Last seen May 25, 2016 - May 25, 2016 at 04:47 PM
 Blocked Profile - May 25, 2016 at 04:54 PM

I have a basic function to search a cell for a specific text string (in this case, the name of an application) and return a value to another cell if the text is found:


I would like to be able to search each cell for multiple text strings and return a value for each text string that is found:


(i.e., if the words App1, App2, or App3 are found, return "App1," "App2," "App3" to a different cell). I need a complex function that will allow for multiple searches on a single cell and return only the values that are found.

Is this possible?

Thanks in advance for your help!

1 response

Blocked Profile
May 25, 2016 at 04:54 PM