how to split one cell into multiple rows?

[wondering]

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!

 

[Pete_UK]

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