View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mr_espresso mr_espresso is offline
external usenet poster
 
Posts: 5
Default How to search a cell for multiple keywords?

Since the search function only allows one search term at a time, how
can one search a cell for several keywords?

For example, I want to search a survey comments field for terms like
<doctor, nurse, paramedic and I need to use wildcards like <doct*.
Ideally the function would return a 1 if one or more of the keywords
is present, and a 0 if none are found.

My apologies if this question already has been addressed, but I didn't
see anything in the archives.

Thank you in advance!