There are two ways to concatenate cells with a line break in Google Sheets:

**Method 1: Use CONCATENATE()**

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

**Method 2: Use TEXTJOIN()**

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

Both formulas will concatenate the values in cells **A1** and **A2** with a line break.

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

The following examples show how to use each method in practice with the following two cells in Google Sheets:

**Example 1: Use CONCATENATE() to Concatenate with Line Break in Google Sheets**

We can type the following formula into cell **C1** to concatenate the strings in cells **A1** and **A2** using a line break:

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

The following screenshot shows how to use this formula in practice:

Notice that the strings in cells **A1** and **A2** have been concatenated with a line break.

**Example 2: Use TEXTJOIN() to Concatenate with Line Break in Google Sheets**

We can type the following formula into cell **C1** to concatenate the strings in cells **A1** and **A2** using a line break:

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

The following screenshot shows how to use this formula in practice:

Notice that the strings in cells **A1** and **A2** have been concatenated with a line break.

**Note**: The argument **TRUE** specifies that empty cells should be ignored.

This method is particularly useful when you have several cells to concatenate with line breaks.

For example, the following screenshot shows how to use the **TEXTJOIN()** function to concatenate each cell in the range **A1:A5** with line breaks:

Notice that each cell in the range has been concatenated into a single cell with line breaks.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Use a Concatenate If Formula

Google Sheets: How to Use CONCATENATE with a Space

Google Sheets: How to Use CONCAT with QUERY