Hi Mr.Pearson,

a1&char(10)&a2 works well, but how to make the containing cell collapse
automatically when it contains multiple lines

Clara
--
thank you so much for your help


"Chip Pearson" wrote:

Susan,

Try something like

=A1&CHAR(10)&A2

or, in VBA

Range("B1").Value = Range("A1").Value & Chr(10) &
Range("A2").Value

Ensure that the cell has Wrap Text enabled (Format menu, Cells,
Alignment tab).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Susan W" <Susan wrote in message
...
I want to concatenate values from multiple cells into one cell.
I want a
line-feed separating the values in the combined cell. I tried
using the
ASCII character code (10 for linefeed, 13 for carriage return),
but its not
working the way I did it.

Any help is greatly appreciated.