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.
|