Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Split text into multiple columns using a common delimiter | Excel Discussion (Misc queries) | |||
split one column to multiple columns | Excel Worksheet Functions | |||
split one column into multiple columns | Excel Discussion (Misc queries) | |||
How to split columns with multiple lines w/in cells | Excel Discussion (Misc queries) | |||
How do I split a cell into multiple rows/columns? | Excel Discussion (Misc queries) |