To concatenate strings in Google Sheets with a separator, you can use either the ‘CONCATENATE’ function, the ‘&’ operator, or the ‘TEXTJOIN’ function. We’ll discuss these methods in more detail below.
Follow the steps below to concatenate with separators in Google Sheets using the ‘CONCATENATE’ function.
Open the specific Google Sheet containing your data. In this example, our data includes first names, last names, and email domains.
Select cell D2 to input the concatenated full name.
In cell D2, enter =CONCATENATE(A2, " ", B2) to concatenate the first name from A2 with the last name from B2 using a space as the separator.
Execute the formula by pressing Enter, and observe "John Doe" appear in cell D2.
Follow the steps below to easily set up Google Sheets to concatenate with separators using the ‘&’ operator.
Make sure your Google Sheet with the dataset is open. We’ll use the same dataset as the previous example for better illustration.
Choose cell E2 for the email address result.
In cell E2, input =A2 & "." & B2 & "@" & C2 to craft an email address combining the first name, last name, and email domain appropriately.
Click 'Enter' to generate "John.Doe@example.com" in cell E2, illustrating effective concatenation for email creation.
Ensure the Google Sheet with your names and domains is ready.
Highlight cell F2 for the outcome of the TEXTJOIN formula.
Fill in =TEXTJOIN(" ", TRUE, A2, B2) in cell F2 to concatenate the first and last names, using a space as the delimiter and ignoring empty cells.
Press Enter to merge the names into "John Doe" shown in cell F2, completing the TEXTJOIN concatenation process.
We hope that you now have a better understanding of how to set up Google Sheets to concatenate using different methods.
If you enjoyed this article, you might also like our article on how to concatenate commas in Google Sheets or our article on how to set up Google finance in Google Sheets.
