I need a formula that I can search for the existance of one of multiple strings in a cell

I want to search wether a cell contains either "office" or "excel" or "access".
The formula should also give a succes when multiple of the strings are present in the cell.
itbabeAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
If you normally use a semicolon in formulas rather than a comma, you need:

=COUNT(SEARCH({"Office";"Excel";"Access"};A1))>0

0
 
Rory ArchibaldCommented:
=COUNT(SEARCH({"Office","Excel","Access"},A1))>0

for example.
0
 
itbabeAuthor Commented:
When I paste this exact formula in excel I get a message that it contains an error.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.