Alt Enter

[Guest]

Is there any way to put an Alt Enter into a formula? I am concatenating some
text and I would like to insert an alt enter. I tried the Char(10) from VBA,
but this did not work.

formula is =A1&" "&B1&" "&C1

I would like an Alt Enter after the B1

thanks

Simon

 

[Niek Otten]

Hi Simon,

=A1&" "&B1&CHAR(10)&" "&C1

Then format>Cells>Alignment, check Wrap Text

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Frank Kabel]

Hi
=A1 & CHAR(10) & B1
and format the cell with word wrap