Alt Enter

S

Simon Shaw

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
 
N

Niek Otten

Hi Simon,

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

Then format>Cells>Alignment, check Wrap Text

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top