how i delete other like words in excel?

[mohsen]

mean i have about 1000 words that 300 words is like other , i insert all word
to excel, now how i delete 300 other words ?

 

[Mike]

Multiple methods described below.

http://www.cpearson.com/excel/duplicat.htm#Replacing

or

select your column and then data - filter - advanced filter -unique items
only and filter to another location and delete your original list.

Mike