Table of Contents
CONCATENATE is a function in Google Sheets that allows users to combine or merge data from different cells into one cell. In order to use CONCATENATE with a space in Google Sheets, users can simply include a space within quotation marks (” “) between the cell references or text strings they want to join together. This will result in a single cell containing the combined data with a space in between. This feature is useful for creating organized and visually appealing data sets in Google Sheets.
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)
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.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I use CONCATENATE with a space in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-concatenate-with-a-space-in-google-sheets/
stats writer. "How can I use CONCATENATE with a space in Google Sheets?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-concatenate-with-a-space-in-google-sheets/.
stats writer. "How can I use CONCATENATE with a space in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-concatenate-with-a-space-in-google-sheets/.
stats writer (2024) 'How can I use CONCATENATE with a space in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-concatenate-with-a-space-in-google-sheets/.
[1] stats writer, "How can I use CONCATENATE with a space in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use CONCATENATE with a space in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.