how i delete other like words in excel?
 

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 ?

how i delete other like words in excel?
 

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

"mohsen" wrote:

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 ?