Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to Find more than one string with Microsoft Office Excel?

For example, I am looking for the cells which is contained both strings Paul and John?

How to avoid to perform several finds by permuting arguments like that:

  • first search: find Paul*John

  • second find: search John*Paul

Imagine with n arguments ! !n permutations...

It seems to be impossible by the GUI. And what about macro or anything else?

share|improve this question

migrated from stackoverflow.com Apr 21 '10 at 14:55

This question came from our site for professional and enthusiast programmers.

1  
please elaborate on the details of what you are trying to Find – Raj More Apr 21 '10 at 14:38
    
You need to give more information. Currently, a valid answer would be "Use the search function twice", which may not what you are looking for. – Jens Apr 21 '10 at 14:38

You can get all combinations of strings with the two words using two searches using the wildcard operator:

Paul*John - returns all instances of Paul somewhere before John
John*Paul - returns all instances of John before Paul
share|improve this answer

If it's restricted to a single column then switching on AutoFilter and setting a custom filter might be the way to go.

If it's anywhere on the worksheet you're probably restricted to multiple searches

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .