Concatenate Carriage Return

  • Thread starter Thread starter tbieri
  • Start date Start date
T

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
 
Turn on wrap text under format>cells>alignment and use something like

=A2&CHAR(10)&B2&CHAR(10)&C2
 
Thanks, I figured it was simple. I recorded a macro and it
used CHR(10), not CHAR(10).
 
Back
Top