delete duplicate listings in excel/word

  shauny36 19:03 04 Apr 2008

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 2008

am using word/excel 2007

  VoG II 19:08 04 Apr 2008

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires