In cell C1:

=A1 & CHAR(10) & A2 & CHAR(10) & A3

Format C1 for word wrap.

HTH,
Bernie
MS Excel MVP


"KUMPFfrog" wrote in message
...
I try to use ALT+ENTER in a function, but the result is a continous line.
ex.
C1=A1
&A2
&A3

Is there any way to produce a result in C1 with hard breaks?