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.
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.
Select cell D2 as the destination for the concatenated string. This is where the combined information will appear.
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".
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.
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.
Again, use cell D2 for the output of the concatenated string.
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.
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.
