Hi Sat,

See Chip Pearson's Duplicates page at:

http://www.cpearson.com/excel/duplicat.htm

Alternatively, consider using the Asvanced filter feature, using the Uniques
option.

If you are not familiar with Advanced Filter, see Debra Dalgleish's tutorial
ay:

http://www.contextures.com/xladvfilter01.html


---
Regards,
Norman



"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