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

Report
Posts
1
Registration date
Wednesday May 25, 2016
Status
Member
Last seen
May 25, 2016
-
 Blocked Profile -
Hello,

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:

=IF(ISERROR(SEARCH("*App1*",H2,1)),"","App1")

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:

=IF(ISERROR(SEARCH("*App1*",H2,1)),"","App1")
=IF(ISERROR(SEARCH("*App2*",H2,1)),"","App2")
=IF(ISERROR(SEARCH("*App3*",H2,1)),"","App3")

(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!