Copying a multiline text into a single cell in Excel
To paste multi-line content in Excel, all you need to do is double click the new cell (so you see the arrow 'thing' blinking), and paste (ctrl + V):
If you have to do this for more than one cell:
- Replace all linebreaks in word (
^p
or^l
) with something you can replace (I useLINEBRK
).- Paste into Excel.
- Replace all
LINEBRK
with the newline/linefeed character generated byAlt+0010
(hold downAlt
on your keyboard and then hit0010
on your number pad) or hitCtrl + J
.- Re-do/re-apply Wrap Text in Excel.
Source: Remove Replace or Separate by Line Breaks
I had the same problem now.
I found a different (in some cases a better) solution.
If you can, surround the clipboard content with quotation marks:
"line1
line 2
line 3"