="a"&CHAR(10)&"b"

FormatcellsAlignment, check Wrap text

--
Kind regards,

Niek Otten

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