I have a 1800 line address book in excel. I would like to get rid of duplicates. Is there an easy formula that will highlight and the delete or assign a character in another cell that I could sort then delete? Thanks in advance UPDATE... I Figured that part out. Now I want to make address labels from this list