CONCATENATE Multiple cell in one

Question

I want to merge A to Z cell in one with line break, Please tell me it's short form every two sell merge with line break A - Z

=CONCATENATE(A1,"
",B1,"
",C1,"
",D1,"
",E1,"
",F1,"
",G1,"
",H1,"
",I1,"
",J1,"
",K1,"
",L1,"
",M1,"
",N1,"
",O1,"
",P1,"
",Q1,"
",R1,"
",S1,"
",T1,"
",U1,"
",V1,"
",W1,"
",X1,"
",Y1,"
",Z1)```

`=TEXTJOIN(CHAR(10),TRUE,A1:Z1)` – Scott Craner Jul 27 '22 at 18:57 — Scott Craner, Jul 27 '22 at 18:57

score 2 · Accepted Answer · answered Jul 27 '22 at 19:10

2

try:

=TEXTJOIN(CHAR(10); 1; A1:Z1)

answered Jul 27 '22 at 19:10

player0

124,011
12
67
124

CONCATENATE Multiple cell in one

1 Answers1