Split cells across multiple columns

  • Thread starter Thread starter Kiran Kiran
  • Start date Start date
K

Kiran Kiran

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
 
You have one column of single text entries in 1000 cells?

What are you trying to split?

Do you want the column to be re-arranged into 5 columns with 200 entries per
column?

Do you want them snaked top to bottom or what arrangement?

Please show a small sample of what you have and what you want.


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 12:06:01 -0800, Kiran Kiran <Kiran
 
Back
Top