View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wondering Wondering is offline
external usenet poster
 
Posts: 3
Default 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!