Hi,

Adding a new line in a cell is done by Alt+Enter, but when I reference a cell with text on two or more lines, the text is displayed on a single line.

How can I keep the formatting in the cell with reference to another? Is it possible?

Example:
Cell A1 contains
"Hello
World!"

Cell B1 contains
=A1
displaying: "Hello World!"

Is there a way to keep the line break in cell B1?

BR
Daniel