look for two strings within text

[ajm]

what is the most efficient way to look for either this or that within a string. if found, they will be removed or replaced with a blank.

 

[Rick Rothstein]

what is the most efficient way to look for either this or that within a string. if found, they will be removed or replaced with a blank.

It depends... are you looking for a case sensitive replacement or a case insensitive replacement?

 

[ajm]

Sorry Rick for not responding. I found a solution at:

https://stackoverflow.com/questions/14803944/excel-searching-for-multiple-terms-in-a-cell

=if(SUMPRODUCT(--(NOT(ISERR(SEARCH({" New"," Review"},$F3)))))>0,"1","")