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 cells with a line break in Excel
COMBINE TWO OR MORE CELL WITH LINE BREAK — EXCEL FORMULA AND EXAMPLE
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 cells with a line break in Google Sheets
COMBINE TWO OR MORE CELL WITH LINE BREAK — GOOGLE SHEETS FORMULA AND EXAMPLE
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
Other useful Excel and Google Sheets to combine cells and columns data
- Combine two or more cell
- Combine multiple columns into one single column
- Combine two or more cells and transpose
- Combine data from multiple Google Sheets tabs and get sheet/tab name
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria