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

itbabe
itbabe used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2011

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

for example.

Author

Commented:
When I paste this exact formula in excel I get a message that it contains an error.
Most Valuable Expert 2011
Top Expert 2011
Commented:
If you normally use a semicolon in formulas rather than a comma, you need:

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial