Concatenate Carriage Return

[tbieri]

Hi,

Is it possible to concatenate a carriage return (ALT
Enter)? I want to take three cells and place them in a
single cell on three lines.

Regards,
Tim

 

[Peo Sjoblom]

Turn on wrap text under format>cells>alignment and use something like

=A2&CHAR(10)&B2&CHAR(10)&C2

 

[tbieri]

Thanks, I figured it was simple. I recorded a macro and it
used CHR(10), not CHAR(10).

 

[Dave Peterson]

It's different in VBA than in the worksheet.

Thanks, I figured it was simple. I recorded a macro and it
used CHR(10), not CHAR(10).