Thanks Rafael, thats great. I used the second method coz I don't even
know how to get into VBA.

Anyway, now I have a slightly different problem which hopefully you can
help with.

I have 2 columns of email addresses. I have imported them from
different sources.

I need to remove the duplicate entries so I placed one set under the
other.

Then I tried the Filter ~ Advanced Filter trick.

It didn't remove any because I found that the 2nd set does not match
the first set because it has a lot of trailing edge spaces after the
email address.

What can I do to remove these trailing edge spaces and make them the
same as the 1st set?

JH


--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile: http://www.excelforum.com/member.php...o&userid=10073
View this thread: http://www.excelforum.com/showthread...hreadid=395116