Select the column. Then Data > Filter > Advanced Filter > check unique
records only. If you later want to restore the duplicates, you can. If you
want to permanently delete the duplicates, copy the column elsewhere.
--
Gary's Student
"sat" wrote:
> XL 2002 SP3, Win XP HE SP1
> Follow up to: microsoft.public.excel.misc
>
> Hi, what is the BEST way to remove duplicate cells (phone numbers, email
> addresses, etc.) from a long list in Excel?
>
> The duplicates usually would be in 1 column (Column "A: for example)
>
> Tx. S
>
>
>
Bookmarks