Learn To Concatenate Multiple Contiguous Cells

In Google Sheets, you can concatenate multiple contiguous cells using the CONCATENATE function, the & operator, or the TEXTJOIN function. Here's how to use each method:

Method 1: Using CONCATENATE Function

If you want to concatenate a specific range of cells:

1. Select the cell where you want to display the result.
2. Use the CONCATENATE function:

   =CONCATENATE(A1, A2, A3) 
   

   Replace A1, A2, and A3 with the actual cell references.

Method 2: Using the & Operator

You can also use the & operator to concatenate the cells:

=A1 & A2 & A3

Again, replace A1, A2, and A3 with the actual references.

Method 3: Using TEXTJOIN Function

If you need to concatenate a range of contiguous cells with a delimiter (like a space or comma), TEXTJOIN is very convenient:

1. Select the cell where you want to display the result.
2. Use the TEXTJOIN function:

   =TEXTJOIN(", ", TRUE, A1:A3)
   

   Here, ", " is the delimiter (a comma and space), TRUE ignores empty cells, and A1:A3 is the range of cells to concatenate.

Example

If you have values in cells A1 (Hello), A2 (World), and A3 (2023):

1. Using CONCATENATE:

   =CONCATENATE(A1, " ", A2, " ", A3)
   

   This would output: Hello World 2023

2. Using & Operator:

   =A1 & " " & A2 & " " & A3
   

   This yields the same result.

3. Using TEXTJOIN:

   =TEXTJOIN(" ", TRUE, A1:A3)
   

   This also gives you: Hello World 2023

Choose the method that fits your needs based on whether you want to include a delimiter or handle empty cells!