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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting cells in Excel 2007 1
VBA Multiple Line handling with Split() 1
Split column contents (de-concantenate) 7
Splitting Cell problem 1
Split Cells 2
Excel 2000 - Split Contents of Cell Across Multiple Cells 7
Index/match across multiple columns? 19
Spliting a cell with multiple entries into seperate rows 1

Back
Top