View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
doon doon is offline
external usenet poster
 
Posts: 9
Default parse comma separated text to multiple cells and remove duplic

hi roger,

thanks for your reply. i have already tried the wizard. this results in the
following:

2 RFID Shopping, security, inventory -- Shopping security inventory

across columns. what i want is:

Shopping
security
inventory

this is more of a "text to cells in a colum" function i am looking for. the
layout in my OP was indicative of how i want it. no wizard for that i expect!

thanks nonetheless!