ISTEXT or SEARCH function with 2 variables

Originally Posted by Marcol

One way might be

=IF(ISERROR(FIND("pple",A1,1)),IF(ISERROR(FIND("range",A1,1)),"",A1),A1)

Hope this helps

Thanks for the lightning quick solution!

Quick question, can I use the 'SEARCH' function instead since I thought it is not case sensitive?