Search for multiple keywords within a single text cell

Hi,

Thanks for both of your help. Both functions seem to work fine.

One more quick question: How do I eliminate the #N/A message when the search does not find any keywords within the search string? Can I have it report some other text value instead? I think this would involve the ISERR function, right?

Thanks!