Thread: how i delete other like words in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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 ?
Reply With QuoteReply With Quote