Find more than one string with Excel?

Question

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:

Imagine with n arguments ! !n permutations...

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

please elaborate on the details of what you are trying to Find
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.

heavyd · Answer 1 · 2010-04-21 15:04:06Z

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

Dan Kelly · Answer 2 · 2010-04-22 10:55:11Z

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

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