Using concatenate to create a multiline with references to cells
 

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

Using concatenate to create a multiline with references to cells
 

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

--
Regards,

Juan Pablo González

"Jurry " wrote in message
...
I would like to have in 1 (!) cell several values on multiple lines. The
problem is that the values are actually references to other cells, for
example:

A1="a"
A2="b"

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

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

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

Thanks,
Jurry.


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

Using concatenate to create a multiline with references to cells
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jurry " schrieb im Newsbeitrag
...
I would like to have in 1 (!) cell several values on multiple lines.
The
problem is that the values are actually references to other cells,
for
example:

A1="a"
A2="b"

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

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

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

Thanks,
Jurry.


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

Using concatenate to create a multiline with references to cells
 

Thanks!
Jurry

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