Thanks for the info folks. But The strings I am matching on are less than 255
characters long (no more than about 30 characters). The only other thing I
can think of, maybe the advanced filter criteria can't handle some characters
(the strings I am trying to match on will have period chars, e.g
123.ABC.XYZ). Any ideas?

"simpsons_rule" wrote:

Hi,
I have an advanced filter set up to match on the contents of 4 columns,
using the criteria =("=" & text) . It works fine, except on one column the
text is quite long, and the match only seems to work on part of the text. So
I get matches where the the first part of the text matches, but the end of
the text is different. How can I set up the criteria to get an exact match on
the text regardless of length? Thanks..
--
In the nation of the blind, the one eyed man is king..