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!
