Follow the steps below to concatenate with spaces in Google Sheets.
Ensure you have your Google Sheets document open. For example, this document should include a dataset with "First Name" in Column A and "Last Name" in Column B.
Focus on merging the "First Name" from Column A with the "Last Name" from Column B for each entry. Your goal is to create a full name in a new column by combining these.
In the cell where you wish the full name to appear (e.g., C3 for the first entry), type the formula =CONCATENATE(A3, " ", B3). This command instructs Google Sheets to merge the first name from cell A3 with the last name from B3, adding a space in between.
Alternatively, in cell C3, you can type =A3 & " " & B3. This method achieves the same result as CONCATENATE and merges the text from A3 and B3 with a space in between, but it is more concise.
After entering your formula in C3, press Enter. This action combines the first and last names from A3 and B3, respectively. This displays the full name as "John Doe" in C3.
To apply the name-merging formula to your entire list, select C3 and then drag the fill handle (the small square at the bottom right corner of the cell) down through to C6 or beyond as needed.
This replicates the formula for each row and automatically adjusts the cell references to concatenate names across your list.
If your contact list grows, continue the formula by dragging the fill handle from the last filled cell down to include the new rows. Ensure every new name in columns A and B is accounted for by adjusting the formula's range accordingly.
The ampersand (&) operator in Google Sheets is a simple way to join text strings, including concatenating names, words, or numbers with spaces between them. Here's how to use it:
Ensure the Google Sheets document containing your contact list is open. The list should have "First Name" in Column A and "Last Name" in Column B.
In the cell where you wish the full name to appear (for instance, C2 for the first entry), type the following formula: =A2 & " " & B2
This formula instructs Google Sheets to take the first name from cell A2, add a space, and then append the last name from cell B2.
After entering the formula in C2, press Enter. The cell will now display the combined names as "John Doe," assuming "John" is in A2 and "Doe" is in B2.
To apply this name-merging formula to your entire list, select C2, then drag the fill handle (the small square at the bottom right corner of the cell) down through to the last entry of your list.
This action copies the formula to other rows, adjusting cell references automatically.
The JOIN function in Google Sheets is useful for concatenating a range of cells using a specific delimiter, such as a space. Here's how to use it:
Open your Google Sheets document. For this example, assume you have parts of names or titles spread across columns A to D in a single row that you wish to concatenate.
In the cell where you want the concatenated names to appear (e.g., E2), enter the following formula: =JOIN(" ", A2:D2)
This command uses the JOIN function with a space (" ") as the delimiter to concatenate the contents of cells A2 through D2, adding a space between each element.
Hit Enter after typing the formula. The cell will display the concatenated string with spaces between the contents of each cell in the specified range.
If you're dealing with a different range or a varying number of cells to concatenate, modify the range in the formula accordingly (e.g., A2:B2 if only concatenating two cells).
We hope that you now have a better understanding of how to concatenate with space in Google Sheets.
If you enjoyed this article, you might also like our article on how to concatenate in Google Sheets or our article on how to concatenate multiple cells in Google Sheets.
