I merged a few email lists and want to remove duplicates. How?

[DFDietrich]

I have scores of emails within a WORD document, separated by commas, but in
no particular order. Since I merged a few lists together how can I
effectively search through the list for duplicates and remove them?

 

[JoAnn Paules]

I would convert that text to a single column table, paste that in Excel,
then use ASAP Utilities to lok for duplicates. But that's just how I would
do it.

 

[Graham Mayor]

Emails? Do you mean email addresses? In that case use replace to replace
, with ^p
Then sort the column and use replace to replace
(*^13)@
with
\1
with the wildcard option set to remove duplicates.
See http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>