ExcelBanter - ALT+ENTER IN A FUNCTION

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ALT+ENTER IN A FUNCTION (https://www.excelbanter.com/excel-worksheet-functions/49021-alt-enter-function.html)

KUMPFfrog

ALT+ENTER IN A FUNCTION

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?

Bernie Deitrick

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?

All times are GMT +1. The time now is 10:03 PM.