Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-09-05
3
Medium Priority
?
232 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:itbabe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36484813
=COUNT(SEARCH({"Office","Excel","Access"},A1))>0

for example.
0
 

Author Comment

by:itbabe
ID: 36488224
When I paste this exact formula in excel I get a message that it contains an error.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 36488233
If you normally use a semicolon in formulas rather than a comma, you need:

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

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question