keeping carriage returns with paste link

[Note3of3]

Source: cell is an address for printing on a letter.

Jack's Tavern
1234 bay drive
Jacksmelt city, Fl 33123

Target cell is a paste link of that address. However the paste link loses all the carriage returns making the address one continuous line. Does anyone know a solution to this problem?

Paste links cell results.

Jack's Tavern 1234 bay drive Jacksmelt city, Fl 33123

 

[Note3of3]

I found the solution myself.

go to the paste link cell, right click, Format Cells, go to alignment tab, check mark wrap text, click OK, now the carriage returns will remain intact.