Copy multiple lined cell with formulas into formatted text

[fnmnin]

Hello,

I have a cell that contains an address, populated from other cells and to be set in a specific format (like you would write on an envelope. This is an example of the formula in the ideal format:

="Address: " &
J2 &
K2 & " " & L2

What I want to do is be able to convert that into text but to keep the multiple lined formatting, and to be able to copy the cell as text in that format into another worksheet. I want it to look like this:

Address:
123 SampleStreet
SampleCity SamplePostcode

Whenever I try to copy, whether as 'values', as 'values and number formats' or trying multiple steps using 'formats' first then 'values', it doesn't keep the format.

Can someone help please? Thanks.

 

[fnmnin]

Just refreshing in case anyone is able to help, thanks.

 

[Rick Rothstein]

Give this formula a try (and don't forget to turn "Wrap Text" on and make the column wide enough)...

="Address:"&CHAR(10)&J2&CHAR(10)&K2&" "&L2

 

[fnmnin]

Give this formula a try (and don't forget to turn "Wrap Text" on and make the column wide enough)...

="Address:"&CHAR(10)&J2&CHAR(10)&K2&" "&L2

That does the trick! I have a more detailed formula that I'll check at work tomorrow but I should be able to incorporate your suggestion into it. Thanks.