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