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.
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
If you normally use a semicolon in formulas rather than a comma, you need:


Rory ArchibaldCommented:

for example.
itbabeAuthor Commented:
When I paste this exact formula in excel I get a message that it contains an error.
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.