Search Cell for Multiple Text Strings, Return each found value [Closed]

Registration date
Wednesday May 25, 2016
Last seen
May 25, 2016
 Blocked Profile -

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 reply

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!