In this article:

Concatenate with Space in Google Sheets (2024 Update)

Concatenate with Spaces in Google Sheets 

Follow the steps below to concatenate with spaces in Google Sheets.

1. Open Your Google Sheet Containing the Contact List

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.

concatenate with space google sheets

2. Decide Which Cells to Merge with a Space

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.

concatenate google sheets with space

3. Combine Names Using the CONCATENATE Function in Google Sheets

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.

google sheets concatenate with space

4. Shortcut: Merge Names with the "&" Operator

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.

add space in concatenate google sheets

5. Apply the Formula to Display Combined Names

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.

concatenate in google sheets with space

6. Extend the Formula to Other Rows for All Contacts

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.

how to add space in concatenate google sheets

This replicates the formula for each row and automatically adjusts the cell references to concatenate names across your list.

concatenate with a space google sheets

7. Modify the Formula for Additional Names as Required

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.

Concatenate with Spaces in Google Sheets ‍Using the Ampersand (&) Operator 

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:

1. Open Your Google Sheet

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.

concatenate with space google sheets

2. Type the Concatenation Formula Using the Ampersand Operator in a New Column

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.

3. Press Enter

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.

4. Drag the Fill Handle Down to Apply the Formula

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.

Concatenate with Spaces in Google Sheets Using the JOIN Function

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:

1. Prepare Your Google Sheet

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.

2. Enter the JOIN Function Formula

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.

3. Press Enter

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.

4. Modify and Apply the JOIN Function for Different Ranges 

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. 

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started