How to combine cells with line break / carriage return in Excel?

---

Combine multiple cells with line break with CONCATENATE and CHAR functions

---

In Excel, we can use the CONCATENATE to combine the cells then apply CHAR function to insert the line break. Please do as follows:

1. Enter this formula: =CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10)) into a blank cell, A6, in this case, see screenshot:

2. Then drag the fill handle right to the cells that you want to apply this formula, and all the rows have been combined into a cell in a line, see screenshot:

3. After combining the rows, then click Home > Wrap Text, and all the combined contents have been separated by line break, see screenshot:

Notes:

1. In the above formula, A1, A2, A3 are the cells value that you want to combine, and the CHAR(10) is used to enter line breaks in the cell.

2. If you need to combine multiple columns and cells into one cell, you just need to change the cell reference and join with the CHAR(10).

For Example, to combine the columns of each row into one cell with line break, please apply this formula: =CONCATENATE(A1,CHAR(10),B1,CHAR(10),C1,CHAR(10),D1,CHAR(10)), after applying the formula, please remember to make the cells Wrap Text, and you will get the following result:

---

Combine cell contents with line break, comma, space and other separators: With Kutools for Excel’s Combine function, you can quickly combine or merge the cell contents based on column, row or range into rows, columns or one single cell without losing data. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

---

Combine multiple cells with line break with Kutools for Excel

If there are multiple cells needed to be combined, the formula will be much complicated, here, I will introduce you an easy and handy tool--Kutools for Excel, with its Combine Rows, Columns or Cells without Losing Data feature, you can quickly merge multiple rows, columns or cells into a cell separated by comma, semicolon, line break and other characters.

If you have installed Kutools for Excel, please do as follows:

1. Select the data range that you want to combine, and then click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data, see screenshot:

2. In the popped out dialog box, do the following options:

(1.) To combine multiple columns into one cell with the line break, please do:

• A: Select Combine columns under the To combine selected cells according to following options;
• B: Check New line under the Specify a separator;
• C: Choose one place where to put the combined result, you can put it on left cell or right cell;
• D: Specify how you want to deal with the combined cells. You can keep or delete contents from those combined cells, and you can also merge those combined cells.

After finishing the above settings, please click Ok or Apply button, you will get the following result:

(2.) To combine multiple rows into one cell with the line break, please do:

• A: Select Combine rows under the To combine selected cells according to following options;
• B: Check New line under the Specify a separator;
• C: Choose one place where to put the combined result, you can put it on top cell or bottom cell;
• D: Specify how you want to deal with the combined cells. You can keep or delete contents from those combined cells, and you can also merge those combined cells.

Then click Ok or Apply, the rows have been combined into one cell which separated by line break, see screenshot:

(3.) To combine multiple cells into one cell with the line break, please do:

• A: Select Combine into single cell under the To combine selected cells according to following options;
• B: Check New line under the Specify a separator.

And then click Ok or Apply, all the selected cells are combined into one cell with line break, see screenshot:

Click to know more about this Combine feature.

Download and free trial Kutools for Excel Now !

---

Demo: Combine multiple cells with line break with Kutools for Excel

---

Related articles:

Merge and Combine Columns without Losing Data in Excel

Merge cells (combine cells contents) in Excel without losing data

Merge and combine rows without losing data

Combine cells into a cell with space, commas and semicolon

---