Can't optimize a formula to serve the purpose

[shahin]

I've written a formula in excel which is able to find any specific text from a column, no matter how many times it has appeared. However, i expect to optimize the formula a little bit by adding another keyword for search.

Here is the formula I was trying with:
=IF(ISERR(SEARCH("mac",A1)),"",A1)

If i want to search "mac" or "kelvin", then I get stuck.

 

[NARAYANK991]

Hi ,

Try this :

=IF(AND(ISERR(SEARCH({"mac","kelvin"},A1))),"",A1)

Narayan

 

[shahin]

No way, Narayan. Your solution always rocks. One last thing: I could notice that it can handle all cases whether the keyword is Mac, MAC or MaC. Is it excel's built-in feature or it is happening by any chance in my case? Thanks.

 

[NARAYANK991]

Hi ,

That is because the SEARCH function is case-insensitive ; the FIND function is case-sensitive.

Narayan