ALT+ENTER IN A FUNCTION

K

KUMPFfrog

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?
 
B

Bernie Deitrick

In cell C1:

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

Format C1 for word wrap.

HTH,
Bernie
MS Excel MVP
 
Top