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

Split cells across multiple columns
 

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
wrote:

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