Funny. I was just looking at this web page that demonstrates how to do
this. I haven't tried it myself but it is a place to start:

http://j-walk.com/ss/excel/tips/tip47.htm


"Ada" wrote in message
...
I have a spread sheet with about 5,000 names, addresses,
phone # and fax #.

I would like to get rid of the duplicates... without
doing them one by one or shift highlight then delete...

can anyone help me?