View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
abakr abakr is offline
external usenet poster
 
Posts: 1
Default how to preserve paragraph breaks in pasted text?

This can also be solved by double-clicking into a cell and pasting (ctrl-v)
your copied text into it, this will work as well.

"Bob" wrote:

When I paste text copied from a Word document into an Excel cell, Excel
breaks the pasted text into separate cells according to the paragraph breaks
contained in the pasted text. However, I would like to preserve those
paragraph breaks and keep all the pasted text in the same cell.

I realize that when entering text in a cell, I must insert Alt+Return to get
a paragraph break to stay in the cell. But there doesn't seem to be a way to
force pasted text to stay in a single cell when it contains paragraph breaks.

Any advice would be most appreciated.