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)
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