delete duplicate listings in excel/word

  shauny36 19:03 04 Apr 08

am trying to sort out my music list by there are lots and lots of duplicate lists.have got in excel and word.

eg: abba-best of
britney spears-variuos
britney spears-variuos
cool for cats-various
depache mode-greatest hits
depache mode-greatest hits
eminem-curtain falls

so any that are duplicated twice i want to delete
but have a very very large list and a lot of duplicates so dont want to type in the artist or song etc.

or is there another program i can use then copy it back into excel/word.

  shauny36 19:04 04 Apr 08

am using word/excel 2007

  VoG II 19:08 04 Apr 08

In Excel 2007 (only) select your cells, then on the Data tab click Remove Duplicates.

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017