I am trying to isolate unique enteries from a list using the advance filter.
Each cell contains text. There are some cells that contain the same text,
but the spacing before the text is different. The advance filter does not
recognize these as unique enteries. I have tried to clear the formatting of
the cells and this doesn't work. Anyway, to make the advance filter to
ignore spacing and just look at text. Any other suggestions????

Thanks
DAN