Thread: delete duplicate then combine text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gr_jafari gr_jafari is offline
external usenet poster
  
Posts: 6
Default delete duplicate then combine text
I have thoes text in A1:A5 and now want to have that string in A6 , pleas any
help

ColumnA
1 book
2 pencil
3 pen
4 pen
5 book
6 book,pencil,pen

Reply With QuoteReply With Quote