Trying to contatenate multiple cells, with a "soft return" between each

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi everyone!

Is anyone familiar with adding soft returns to a
concatenate function? I've tried everything, but it just
doesn't seem to work. Is there a function that will add a
soft return in a cell?

Thanks to anyone that can help!
 
One way

=A1&CHAR(10)&B1

or using concatenate

=CONCATENATE(A1,CHAR(10),B1)

you have to turn on text wrap under format>cells>alignment
 
Back
Top