# 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 — 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 — 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

Coming | Subscribe here for the custom Excel/Sheets formulas E-book (PDF) >