advanced filter - can't match a long text cell
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..
|