| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to split one cell into multiple rows?
I have hundreds of cells that contain multiple lines. For example, in one
cell, I have apple orange banana etc. Now I want to break them into several rows. I know one way I could do is to highlight the content of the cell and paste it into another cell. However, this task is huge since I have hundreds of such cells. Could some experts help me on this? Thanks a lot! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to split (half) one cell w/o changing col or rows. | Excel Discussion (Misc queries) | |||
| Split cell data in mutiple rows | Excel Discussion (Misc queries) | |||
| How do I split a cell into multiple rows/columns? | Excel Discussion (Misc queries) | |||
| Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) | |||
| using multiple split cell references in linest | Excel Worksheet Functions | |||
Threaded Mode
