Google Sheets: Use CONCATENATE with a Space


You can use the following basic syntax to concatenate strings with a space in Google Sheets:

=CONCATENATE(A2, " ", B2)

This particular formula will concatenate the strings in cells A2 and B2 with a space in between the strings.

The following example shows how to use this formula in practice.

Example: Concatenate Strings with Space in Google Sheets

Suppose we have the following dataset in Google Sheets that contains the city location and team name of various basketball teams:

If we use the following CONCATENATE function to concatenate the city and team names into one cell, no space will be added by default:

=CONCATENATE(A2, B2)

To concatenate with a space, we must explicitly use a space:

=CONCATENATE(A2, " ", B2)

Google Sheets concatenate with a space

Notice that the city and team names have been concatenated with a space.

If we’d like, we can also add additional text to any location in the string.

For example, we can include “Team: ” in the CONCATENATE function:

=CONCATENATE("Team: ", A2, " ", B2)

Feel free to include as many strings and as many variables as you’d like in the CONCATENATE function, each separated by a comma.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Remove Substring in Google Sheets
How to Extract Numbers from String in Google Sheets
How to Convert Dates to Strings in Google Sheets

Featured Posts

Leave a Reply

Your email address will not be published. Required fields are marked *