Take a look he

http://cpearson.com/excel/deleting.h...eDuplicateRows

In article ,
"sat" <saturnin02_at_hotmail.com wrote:

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)