Once you do the Text to columns function, then you can run TRANSPOSE to
convert horizontal data to vertical. Here's some info:
http://www.ozgrid.com/Services/excel-copy-formulas.htm


--
Brevity is the soul of wit.


"doon" wrote:

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!