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

--
Message posted from http://www.ExcelForum.com