What Is Concatenate In Google Sheets?
Concatenate in Google sheets is used to combine the data in two different cells. It is used to help users join or combine data in various cells using the inbuilt concatenate function in Google sheets.
For example, consider the below table showing the first and last names of a fictional character, Harry Potter on the first and last name basis in column A and B respectively.
Now, let us learn how to use the concatenate function in Google sheets with the help of the following examples.
To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C2. Next, select the cell where we want to find the result. In this example, it is cell C2. Now, insert the CONCATENATE function formula in Google sheets.
So, the formula is =CONCATENATE(A2:B2). Press Enter key. We can see the result as shown in the below image.
In this article, let us learn how to use CONCATENATE function in Google sheets with detailed examples.
Table of contents
Key Takeaways
- Concatenate function in Google sheets is used to join or combine the data or text string in various individual cells.
- In Google sheets, concatenate is an inbuilt function. The formula of Google sheets concatenate function is =CONCATENATE(str1,str2,…) where
- str1 is the mandatory argument showing the first value in the dataset
- str2 is the optional argument indicating the data which we can combine along with the first argument.
- Using concatenate, we can combine both numeric values and text values in Google sheets.
- Remember, we can insert a space character (“ “) in the formula to join the data with a space in between the values.
Syntax
The syntax or formula of CONCATENATE function in Google sheets is =CONCATENATE(str1,str2,…) where
- str1 shows the first value in the dataset to be combined in the Google sheets. It is a mandatory argument.
- str2 shows the additional argument which indicates the data to be combined along with the first argument. It is an optional argument.
How To Use Concatenate In Google Sheets?
Concatenate in Google sheets helps users combine the data. Using the below steps, we can concatenate data.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. Next, select the cell where we want to find the result.
Step 2: Now, insert the CONCATENATE function formula in Google sheets.
Step 3: Press Enter key.
We will be able to see the result in Google sheets.
For example, consider the below table showing the first and last names in column A and B respectively.
Now, let us learn how to use the concatenate function in Google sheets with the help of the following examples.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, it is cell C2.
Step 2: Now, insert the CONCATENATE function formula in Google sheets.
So, the formula is =CONCATENATE(A2,B2)
Step 3: Press Enter key.
We can see the result as shown in the below image.
Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.
Likewise, we can use CONCATENATE function.
Examples
Let us learn how to concatenate data in Google sheets with detailed examples.
Example #1 – Concatenate Date And Time
We can concatenate date and time in Google sheets. For example, consider the below table showing the date and time in column A and B respectively.
Now, let us learn how to use the combine date and time in cell C1.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C1. Next, select the cell where we want to find the result. In this example, it is cell C1.
Step 2: Now, insert the CONCATENATE function formula.
So, the formula is =A1+B1
Step 3: Press Enter key.
We can see the result as shown in the below image.
Likewise, we can combine date and time in Google sheets.
Example #2 – Concatenate Columns
We can concatenate columns in Google sheets. For example, consider the below table showing the first and last names of scientists on the first and last name basis in column A and B respectively.
Now, let us learn how to use the concatenate function with the help of the following examples.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, it is cell C2.
Step 2: Now, insert the CONCATENATE function formula.
So, the formula is =CONCATENATE(A2,B2)
Step 3: Press Enter key.
We can see the result as shown in the below image.
Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.
Likewise, we can use CONCATENATE function.
Example #3 – Concatenate With Space
We can concatenate with space in Google sheets. Let us use the same example we used in the concatenate columns example.
For example, consider the below table showing the first and last names of scientists on the first and last name basis in column A and B respectively.
Now, using the concatenate function in Google sheets, we can combine the first and last names in column C, as shown in the below example.
But, for presentation purposes, we may need to add a space in between the first and last names in column C.
We can do that using the space character in the concatenate function in Google sheets.
The steps are:
Step 1: To begin with, insert the space character in the concatenate function formula in cell C2.
So, the complete formula is =CONCATENATE(A2,” “,B2)
Step 2: Now, press Enter key.
We can see the result as shown in the below image.
Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.
Likewise, we can use CONCATENATE function with space in Google sheets.
Example #4 – Concatenate With Comma
We can concatenate with comma in Google sheets. For example, consider the below table showing the name and age in column A and B respectively.
Now, let us learn how to use the combine date and time in cell C1.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C1. Next, select the cell where we want to find the result. In this example, it is cell C1.
Step 2: Now, insert the CONCATENATE function formula.
So, the formula is =CONCATENATE(A1,”,”,B1).
Step 3: Press Enter key.
We can see the result as shown in the below image.
Likewise, we can combine date and time in Google sheets.
Example #5 – Combine CONCATENATE With IF Function
For example, consider the below table showing the subjects and marks of students in column A and B respectively.
Now, we have to mark “PASS” for students who have scored 50. For those who haven’t scored lesser or more than 50, we have to mark the name of the student along with marks in column C.
Let us learn how to combine the concatenate with IF function with the help of the following examples.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C4. Next, select the cell where we want to find the result. In this example, it is cell C2.
Step 2: Now, insert the IF function formula in Google sheets.
Step 3: Next, select the arguments B2=50 as the 1st argument. Insert the value “PASS” if the value is true.
Step 4: Next, insert the CONCATENATE function along with the space character.
So, the formula is =IF(B2=50,”PASS”,CONCATENATE(A2,” “,B2))
Step 5: Press Enter key.
We can see the result as shown in the below image.
Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.
Likewise, we can use CONCATENATE with IF function in Google sheets.
Important Things To Note
- Concatenate Google sheets function combines the data in the spreadsheet.
- Users can combine date and time in Google sheets.
- Ensure to add the data format in MM/DD/YYYY format.
- Similarly, we can combine or concatenate data with space, comma and also, concatenate columns in Google sheets.
Frequently Asked Questions (FAQs)
For example, consider the below table showing the first and last names of a fictional character, Ron Weasley on the first and last name basis in column A and B respectively.
Now, let us learn how to use the concatenate function in Google sheets with the help of the following examples.
The steps are:
Step 1: To begin with, insert the data in the Google sheets spreadsheet. In this example, the data is inserted in the cell range A1:C2. Next, select the cell where we want to find the result. In this example, it is cell C2.
Step 2: Now, insert the CONCATENATE function formula in Google sheets.
So, the formula is =CONCATENATE(A2:B2)
Step 3: Press Enter key.
We can see the result as shown in the below image.
Likewise, we can use CONCATENATE function in Google sheets.
We can combine the data without concatenate function. We can simply use the ‘+’ icon between the two cells we want to combine.
So, for example, if we want to combine cell A1 and A2, we need to use the formula, =A1+A2.
Users can simply insert the IF function with concatenate function if the data satisfies the given condition.
The format is =IF(logical_expression,value_if_true,CONCATENATE(str1,str2,…)).
Download Template
This article must be helpful to understand the Concatenate In Google Sheets, with its formula and examples. You can download the template here to use it instantly.
Recommended Articles
Guide to What is the Concatenate In Google Sheets. We explain how to use Concatenate In Google Sheets with examples. You can learn more from the following articles.
Leave a Reply