You can use the **CONCATENATE **function in Excel to concatenate values from multiple cells into one cell.

To use the **CONCATENATE **function with a line break as the delimiter, you can use the following formula:

=CONCATENATE(A2, CHAR(10), B2, CHAR(10), C2)

This particular formula combines the values in cells **A2**, **B2** and **C2** into one cell, using a line break as the delimiter.

**Note**: In Excel, **CHAR(10)** is used to represent a line break.

The following examples shows how to use this formula in practice.

**Example: How to Use CONCATENATE with New Line in Excel**

Suppose we have the following dataset in Excel that shows the title, name and tenure for various people associated with some basketball team:

Suppose we would like to concatenate each cell in each row into one cell, using a line break as the delimiter.

We can type the following formula into cell **D2 **to do so:

=CONCATENATE(A2, CHAR(10), B2, CHAR(10), C2)

We can then click and drag this formula down to each remaining cell in column D:

In order to actually see the line breaks in Excel, we must highlight the cell range **D2:D8** and then click the **Wrap Text** icon within the **Alignment** group in the **Home** tab:

Once we click this icon, we will be able to see the line breaks in column D:

**Note**: You can find the complete documentation for the **CONCATENATE **function in Excel .

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel: