View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sierras
 
Posts: n/a
Default Advanced Filter contains part of a word

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...