Using Advanced Filter with unique items checked is normally a good way to
remove duplicates.

"sat" <saturnin02_at_hotmail.com wrote in message
...
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