Copying a multiline text into a single cell in Excel

I want to copy the following:

line1


line 2


line 3

into a single cell in Excel.

I know that I can use the combination Alt+Enter on Windows and Ctrl+Alt+Enter on Mac to create a line break in the cell, but here I want to copy paste in a single cell, not typing its content.

Here is what I get:

I want it in a single cell with line breaks:

Solution 1:

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):

Solution 2:

If you have to do this for more than one cell:

1. Replace all linebreaks in word (^p or ^l) with something you can replace (I use LINEBRK).
2. Paste into Excel.
3. Replace all LINEBRK with the newline/linefeed character generated by Alt+0010 (hold down Alt on your keyboard and then hit 0010 on your number pad) or hit Ctrl + J.
4. Re-do/re-apply Wrap Text in Excel.

Source: Remove Replace or Separate by Line Breaks