If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
how to split one cell into multiple rows?
Assuming that you have Alt-Enter in those cells causing the data to
wrap, then you could highlight the column then click on Data | Text-to- Columns. In the panel that pops up, click on Delimited, then Next, then in the Other box enter CTRL-J (which is equivalent to Alt-Enter in this case), then click Next, and then on the final panel you might like to change the destination where the parsed columns will go, then click Finish. If it is not Alt-Enter but a space that is causing your cells to wrap (with a narrow column), then follow the method above but indicate that the delimiter is a space on the second panel. Hope this helps. Pete On Nov 26, 10:01 pm, wondering wrote: 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 | |
Display Modes | |
|
|