how to change "Find" feature

[darnat2]

Darwin Wadel

I am wondering if someone could help me a bit, I'm sure this is easy t
many but I know next to nothing about Excel. I have a huge database o
book titles on excel and I need to be able to search the titles with a
least 2 words in the search box, words that are not consecutive in th
title, for instance, in the title "Stephen King, The Barking Dogs"
need to be able to enter "King" and "Dogs" in the find box and have i
find both words in column D in all D cells that have those two words i
it. Now the only way it works is if both words are together. My title
are always in column D. I don't want the search to come back with one o
the other but both search words need to be in the cell regardless i
they are consecutive or not. Is there a code that can be written fo
this? Thankyou very much

 

[Norman Jones]

Hi Darnat2,

Try using the * wildcard to concatenate the search strings, e.g.

*King*Dogs