20 Aug 09 Excel: How to search for multiple strings in a cell

I learned about this technique yesterday.

The problem is as follows: There is a cell that we wanted to find out if it contains at least one of the multiple strings (words or numbers) that we specified.

One real life application is like this. You are given a long list of item descriptions, and you wanted to find out if it contains some specific items such as “pressure cooker”, or “microwave”, etc.