Combine two or more cells with line break in Excel and Google Sheets

=CONCATENATE(A2,CHAR(10),A3)

=TEXTJOIN(CHAR(10),TRUE,A2:A3)

A2, A3 = cells which you want to combine.

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Combine two or more cells with a line break in Excel

How to combine two or more cells with a line break in Excel?
Combine two or more cell with line break in Excel

COMBINE TWO OR MORE CELL WITH LINE BREAK — EXCEL FORMULA AND EXAMPLE

=CONCATENATE(A2,CHAR(10),A3)

    • A2, A3 = data cell to combine, CHAR(10) = line brake

=TEXTJOIN(CHAR(10),TRUE,A2:A3)

    • A2:A3 = data cell to combine,

    • TRUE = ignore_empty

    • CHAR(10) = line brake

Combine two or more cells with a line break in Google Sheets

How to combine two or more cells with a line break in Google Sheets?
Combine two or more cell with line break in Google Sheets

COMBINE TWO OR MORE CELL WITH LINE BREAK — GOOGLE SHEETS FORMULA AND EXAMPLE

=CONCATENATE(A2,CHAR(10),A3)

    • A2, A3 = data cell to combine, CHAR(10) = line brake

=TEXTJOIN(CHAR(10),TRUE,A2:A3)

    • A2:A3 = data cell to combine, TRUE = ignore_empty, CHAR(10) = line brake

=ArrayFormula(CONCATENATE(A2:A3 & CHAR(10)))

    • A2:A3 = data cell to combine, CHAR(10) = line brake