Find "apple" and "orange" in one search

[HerryMarkowitz]

Greetings,
Open an excel file.
Press Ctrl+F to pop up Find and Replace Dialog Box.
How can I search "apple" and "orange" in one search ?
Regards

Supporting link:
http://office.microsoft.com/en-us/ex...001230225.aspx

[XOR LX]

Hi,

What precisely do you mean? You want to locate cells which contain both "Apple" and "Orange" anywhere within the string, but not just "Apple" or just "Orange"?

Regards

[HerryMarkowitz]

Hi XOR LX,
Lets say there is an "apple" in the B5 cell, and there is an "orange" in E8 cell.
I want to search "apple" and "orange" once.
Result must be "apple" in the B5 cell, and "orange" in E8 cell.

My aim is to shorten searching time...
Once search instead of two times...

Regards

[XOR LX]

No. You cannot perform an "OR" operation using the Find and Replace tool.

For that you would require a formula or some VBA.

Regards

[HerryMarkowitz]

I am already using following code...

Please Login or Register  to view this content.

Any idea for searching apple and orange in one search ?

[TKCZBW]

Possibly use a couple of instrings with an or statement between them, then highlight cells that match?

Depending on size of sheet however, doubt it would be quicker! Any time saved in the finding would be outweighed by the time searching via macro and the time needed to un-highlight the cells manually once you'd 'dealt' with them.

I think you might be on to a losing wicket here!

[JOHN H. DAVIS]

What action do you want to perform once found? For instance his will highlight the cells of the first instance of each.

Please Login or Register  to view this content.

[HerryMarkowitz]

Hi JOHN H. DAVIS,
Thanks for the answer.
But I need to see results on the find and replace dialog box in order to manage it properly...

[TKCZBW]

I think John's answer is the best you're going to get I'm afraid, the built-in Find/Replace isn't built to handle queries like that.

[JOHN H. DAVIS]

Does this help any?

Please Login or Register  to view this content.

[HerryMarkowitz]

Hi JOHN H. DAVIS,
Following part of your code has an error...

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Worked when I tested it. What is the error you're getting?

[HerryMarkowitz]

Sorry...My mistake...It is working...

But, this solution is not exactly what I am looking for...

But anyway thank you...

[JOHN H. DAVIS]

Sorry, I couldn't help you further. Hope someone else can.