Join 2 cells with carriage return in between

  • Thread starter Thread starter MaxBrit
  • Start date Start date
M

MaxBrit

Hi

Need to do the following.

Have C1 = A1&B1 but required to have C1 display as 2 lines

A1
B1

i.e. as if Alt-Enter had been used in cell.

Have tried using alt-010 in middle of A1&B1 formula.

How can I get alt-enter into the formula?

Thanks for any help

Regards
Max
 
in C1: =A1&CHAR(10)&B1
and format C1 with word wrap!

Regards,
Stefi

„MaxBrit†ezt írta:
 
Back
Top