I find that using vbLF is a bit more readible and is certainly faster to type
than CHR(10). Am I missing something here?

"Susan W" wrote:

Yes - the Chr(10) did it. Thanks very much!
Susan

"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.