Using concatenate to create a multiline with references to cells

[Jurry]

I would like to have in 1 (!) cell several values on multiple lines. Th
problem is that the values are actually references to other cells, fo
example:

A1="a"
A2="b"

then A3 should be a 2 line cell, which on the first line a reference i
made to A1 and on the second line a reference to A2. I was thinking t
solve this using the function concatenate, using char(10) to create th
multiline:

A3 = concatenate(A1; char(10); A2)

However this does NOT work: the references values are only separated b
a box-sign, indicating a nonpritable character. Does anyone know how t
fix this (the references should stay dynamical!).

Thanks,
Jurry

 

[Juan Pablo Gonzalez]

Make sure that Wrap Text is turned on for that cell.

 

[Frank Kabel]

Hi
goto 'format - Cells - Alignment' and check 'wrap text' for this cell
You may also use the formula
=A1 & CHAR(10) & A2

 

[Jurry]

Thanks!
Jurry