Prev: 2007 to 2003 formatting troubleshooting
Next: Excel Data Validation Combo box using Named Ranges
From: Kiran Kiran Kiran on 17 Feb 2010 15:06
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
From: Gord Dibben on 17 Feb 2010 15:54
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
Kiran(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: 2007 to 2003 formatting troubleshooting
Next: Excel Data Validation Combo box using Named Ranges