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!
|