Search Cell for Multiple Text Strings, Return each found value

Closed
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
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 response

Blocked Profile
May 25, 2016 at 04:54 PM
0