View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kiran Kiran Kiran Kiran is offline
external usenet poster
 
Posts: 1
Default Split cells across multiple columns

Office 2003:
I have a long list of one word entries (over 1000 rows). I would like
to split this across several cells and could not find a way to do that in
Excel Data Menu sections.
I see Data Text to Columns but couldn't get it to work.
Would like to preferably split those across 5 columns, but I
wouldn't know how many rows it would require (need table to
grow automatically).

I will be cut-paste those entries from notepad/textpad.

I wouldn't mind using MS Word if I can get that table contents filled.

Thanks