# How to Concatenate Multiple Cells in Google Sheets (2024 Update)

May 8, 2024

## Google Sheets Concatenate Multiple Strings

Concatenating strings means combining them into one. You can do this in Google Sheets using two methods: the CONCATENATE function and the & operator. Here's a step-by-step tutorial for both methods.

## Concatenate Multiple Cells in Google Sheets Using the ‘CONCATENATE’ function

Follow the steps below to concatenate multiple cells in Google Sheets using the CONCATENATE function.

Open your Google Sheet containing the dataset. We will use cells A2 to C5, which hold first names, last names, and departments.

### 2. Choose the Destination Cell for Your Concatenated String

Select cell D2 as the destination for the concatenated string. This is where the combined information will appear.

### 3. Type the CONCATENATE Formula with Your Specific Cell References

In D2, input the formula =CONCATENATE(A2, " ", B2, ", ", C2). This will merge the first name, last name, and department from row 2 into a format "Jane Doe, Engineering".

### 4. Execute the Formula by Pressing Enter

Press Enter to apply the formula. D2 will now show "Jane Doe, Engineering". Drag the fill handle down from D2 to D5 to apply this formula to the remaining rows.

## How to Concatenate Multiple Cells in Google Sheets Using the ‘&’ Operator

Follow the steps below to concatenate multiple cells in Google Sheets using the ‘&’ Operator.

Ensure the dataset from A2 to C5 is ready. This time, we'll combine the strings using a different method.

### 2. Identify the Target Cell for the Merged String

Again, use cell D2 for the output of the concatenated string.

### 3. Input the & Operator Formula Using Your Cell References

Type A2 & " " & B2 & ", " & C2 in cell D2. This formula also combines the first name, last name, and department but uses the & operator for a simpler syntax.

### 4. Confirm and Display the Concatenated String by Hitting Enter

After entering the formula, press Enter. "Jane Doe, Engineering" will be displayed in D2. Extend this formula to D3 through D5 by dragging the fill handle.

We hope that you now have a better understanding of how to set up Google Sheets to concatenate multiple strings.

If you enjoyed this article, you might also like our article on how to concatenate in Google Sheets with space or our article on how to set up Google Sheets to concatenate with commas.

Get Google Sheets productivity and automation tips delivered straight to your inbox