Table of Contents
Google Sheets is a powerful and user-friendly spreadsheet program that allows users to manipulate and organize data in a variety of ways. One useful feature of Google Sheets is the ability to concatenate, or combine, multiple cells into one cell. This can be particularly helpful when working with large datasets or creating labels or lists. Additionally, by using certain formulas and functions, it is possible to insert a line break between the concatenated cells, making the data easier to read and understand. This feature can be accessed through the use of specific formulas and functions, allowing users to easily and efficiently concatenate and insert line breaks in their data within Google Sheets.
Google Sheets: Concatenate Cells with Line Break
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.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I use Google Sheets to concatenate cells and insert a line break between them?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-concatenate-cells-and-insert-a-line-break-between-them/
stats writer. "How can I use Google Sheets to concatenate cells and insert a line break between them?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-concatenate-cells-and-insert-a-line-break-between-them/.
stats writer. "How can I use Google Sheets to concatenate cells and insert a line break between them?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-concatenate-cells-and-insert-a-line-break-between-them/.
stats writer (2024) 'How can I use Google Sheets to concatenate cells and insert a line break between them?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-concatenate-cells-and-insert-a-line-break-between-them/.
[1] stats writer, "How can I use Google Sheets to concatenate cells and insert a line break between them?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use Google Sheets to concatenate cells and insert a line break between them?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.