Try something like this:

If Col_A, beginning at A1, contains the text values, has a heading of
MyText, and you want to find records where Col_A contains the word "turtle":

The criteria range could be:

C1: MyText
C2: *turtle*

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Sierras" wrote:

I'm trying to get an advanced filter to work so that it will bring back
all records with part of the word rather than just the start of a word.
This works very well when I use AutoFilter with the "Contains" criteria.
But when I do an advanced filter, only records that start with the word
get filtered. What do I have to do to get all the records. Thanks...