All in One Bundle

Concatenate In Google Sheets

Written by ExcelMojo Team ExcelMojo Editorial Team Editorial Team The ExcelMojo Editorial Team creates and improves practical Excel, VBA, Power BI, analytics, and AI spreadsheet resources for learners, analysts, teams, and business professionals. Excel VBA Power BI View Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Co-Founder & Course Director Dheeraj is the founder of ExcelMojo and leads the learning direction across Excel, analytics, financial modeling, valuation, and AI spreadsheet workflows. A former J.P. Morgan and CLSA equity... Financial Modeling Valuation Investment Banking View Full Bio
Updated Apr 22, 2026
Read Time 9 min

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.

Concatenate-In-Google-Sheets-Definition

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.

Concatenate-In-Google-Sheets-Definition-1

In this article, let us learn how to use CONCATENATE function in Google sheets with detailed examples.

Download FREE Concatenate In Google Sheets Template and Follow Along!

Use this Concatenate In Google Sheets Template to follow along with the examples in this article.

Download Excel Template

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

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.

How-To-Use-Concatenate-In-Google-Sheets

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.

How-To-Use-Concatenate-In-Google-Sheets-Step-2

So, the formula is =CONCATENATE(A2,B2)

How-To-Use-Concatenate-In-Google-Sheets-Step-2-1

Step 3: Press Enter key.

We can see the result as shown in the below image.

How-To-Use-Concatenate-In-Google-Sheets-Step-3

Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.

How-To-Use-Concatenate-In-Google-Sheets-Step-3-1

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.

Concatenate-In-Google-Sheets-Example-1

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.

Example-1-Step-3

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.

Concatenate-In-Google-Sheets-Example-2

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.

Example-2-Step-2

So, the formula is =CONCATENATE(A2,B2)

Example-2-Step-2-1

Step 3: Press Enter key.

We can see the result as shown in the below image.

Example-2-Step-3

Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.

Example-2-Step-3-1

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.

Concatenate-In-Google-Sheets-Example-3

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.

Concatenate-In-Google-Sheets-Example-3-1

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)

Example-3-Step-1

Step 2: Now, press Enter key.

We can see the result as shown in the below image.

Example-3-Step-2

Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.

Example-3-Step-2-1

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.

Concatenate-In-Google-Sheets-Example-4

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

Example-4-Step-2

Step 3: Press Enter key.

We can see the result as shown in the below image.

Example-4-Step-3-1

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.

Concatenate-In-Google-Sheets-Example-5

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.

Example-5-Step-2

Step 3: Next, select the arguments B2=50 as the 1st argument. Insert the value “PASS” if the value is true.

Example-5-Step-3

Step 4: Next, insert the CONCATENATE function along with the space character.

So, the formula is =IF(B2=50,”PASS”,CONCATENATE(A2,” “,B2))

Example-5-Step-4

Step 5: Press Enter key.

We can see the result as shown in the below image.

Example-5-Step-5

Now, using the AutoFill option, we can find the result in cells C3 and C4, as shown in the below image.

Example-5-Step-5-1

Likewise, we can use CONCATENATE with IF function in Google sheets.

Important Things To Note

  1. Concatenate Google sheets function combines the data in the spreadsheet.
  2. Users can combine date and time in Google sheets.
  3. Ensure to add the data format in MM/DD/YYYY format.
  4. Similarly, we can combine or concatenate data with space, comma and also, concatenate columns in Google sheets.

Frequently Asked Questions (FAQs)

1. Explain the use of concatenate function with an example.

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.

FAQ-1

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.

FAQ-1-Step-3

Likewise, we can use CONCATENATE function in Google sheets.

2. Can we combine the data without using any formula?

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.

3. How to combine IF function with concatenate function in Google sheets?

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 FREE Concatenate In Google Sheets Template and Follow Along!

Use this Concatenate In Google Sheets Template to follow along with the examples in this article.

Download Excel Template