Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.