How To Combine Text From Two Or More Cells In Google Sheets

What Is Combine Text From Two Or More Cells Into One Cell In Google Sheets?

Combine text from two or more cells into once cell in Google sheets, as the name suggests, helps users combine the data. In other words, it is used to join the data from two cells into one cell.

Now, in Google sheets, we can combine data using ampersand symbol (&), CONCATENATE function in Google sheets, CONCAT Google sheets function and TEXTJOIN function in Google sheet. For example, consider the below table showing first name and last name in columns A and B, respectively.

combine text from two or more cells in GS Definition 1

Now, we need to combine the first name and last name in cells A2 and B2 in cell C2.

To start with, select the cell C2 and insert =A2&” “&B2 and press Enter key.

We will be able to see the result in cell C2, as shown in the below image.

combine text from two or more cells in GS Definition 1-1

Likewise, we can combine text from two or more cells into one cell in Google sheets.

In this article, let us learn how to combine text from multiple cells into one cell in Google sheets with detailed examples.

Combine text from two or more cells into one cell in Google sheets is used to combine the data.
Remember, in spreadsheets, we can combine data from two cells using the CONCAT function in Google sheets.
Similarly, we can also use the ampersand symbol (&) to combine data from two cells in Google sheets.
We can also combine data using CONCATENATE function and TEXTJOIN Google sheets function.
CONCATENATE function helps users combine data from two or more cells in Google sheets.

How To Combine Text From Two Or More Cells Into One Cell In Google Sheets?

We can combine text from two or more cells into one cell in Google sheets using the following methods. They are:

Using ampersand symbol (&)
CONCATENATE function in Google sheets
Google sheets CONCAT function
TEXTJOIN function in Google sheets

Examples

Let us learn how to combine text from two or more cells into one single cell in Google sheets using the below examples.

Example #1 – Using The Ampersand (&) Symbol

For example, consider the below table showing the names of employees, such as first name and last name in columns A and B, respectively.

Using The Ampersand (&) Symbol Example 1

Now, we need to combine both the names in column C using the ampersand (&) symbol in Google sheets.

The steps are:

Step 1: To begin with, we need to insert the data in the Google sheets. In this example, the data is available in the cell range A1:C5. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell C2.

Step 2: Next, insert the & symbol in the formula.

So, the complete formula is =A2&” “&B2

Using The Ampersand (&) Symbol Example 1-1

Step 3: Press Enter key.

We will be able to see the result in cell C2.

Using The Ampersand (&) Symbol Example 1-2

Now, let us use the AutoFill option to find the result in cells C3:C5, as shown in the below image.

Using The Ampersand (&) Symbol Example 1-3

Likewise, we can combine text from two or more cells into one single cell in Google sheets using the ampersand symbol.

Example #2 – Using The CONCATENATE Function

For example, consider the below table showing the name and educational qualification in columns A and B, respectively.

Using The CONCATENATE Function Example 2

Now, we need to combine both the names in column C using the CONCATENATE function in Google sheets.

The steps are:

Step 2: Next, insert Google sheets CONCATENATE function formula.

So, the complete formula is =CONCATENATE(A2,” “,B2)

Using The CONCATENATE Function Example 2-1

Step 3: Press Enter key.

We will be able to see the result in cell C2.

Using The CONCATENATE Function Example 2-2

Now, let us use the AutoFill option to find the result in cells C3:C5, as shown in the below image.

Using The CONCATENATE Function Example 2-3

Likewise, we can combine text from two or more cells into one single cell in Google sheets using the CONCATENATE Google sheets function.

Example #3 – Using The CONCAT Function

For better understanding, let us use the same example we used in Example 2.

Consider the below table showing the names of employees, such as name, education and CONCATENATE result in columns A, B and C, respectively.

Now, we need to combine both the name and education qualification in column D using the CONCAT function in Google sheets.

The steps are:

Step 1: To begin with, we need to insert the data in the Google sheets. In this example, the data is available in the cell range A1:D5. Next, we need to select the cell where we want to find the result. In this example, we need to select the cell D2.

Step 2: Next, insert the CONCAT function in Google sheets formula.

So, the complete formula is =CONCAT(A2,B2)

Step 3: Press Enter key.

We will be able to see the result in cell D2.

Now, let us use the AutoFill option to find the result in cells D3:D5, as shown in the below image.

Likewise, we can combine text from two or more cells into one single cell in Google sheets using the CONCAT function in Google sheets.

Example #4 – Using The TEXTJOIN Function

For example, consider the below table showing the data such as name, age, and gender in column A.

Now, we need to combine the data in cells A2, A3 and A4 in cell B2 using the TEXTJOIN function in Google sheets.

The steps are:

Step 1: To begin with, we need to insert the data in the Google sheets. In this example, the data is available in the cell range A1:B4. Next, we need to select the cell where we want to find the result. In this example, we need to select the merged cell B2.

Step 2: Next, insert the TEXTJOIN Google sheets function in the formula.

So, the complete formula is =TEXTJOIN(” “,TRUE,A2:A4)

Step 3: Press Enter key.

We will be able to see the result in cell B2.

Likewise, we can combine text from two or more cells into one single cell in Google sheets using the TEXTJOIN function in Google sheets.

Example #5 – CONCATENATE With Comma

For example, consider the below table showing the subject and marks in columns A and B, respectively.

Now, we need to combine both the subject and marks in column C using the CONCATENATE function in Google sheets.

The steps are:

Step 2: Next, insert Google sheets CONCATENATE function formula.

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

Step 3: Press Enter key.

We will be able to see the result in cell C2.

Now, let us use the AutoFill option to find the result in cells C3:C5, as shown in the below image.

Likewise, we can combine text from two or more cells into one single cell in Google sheets using the CONCATENATE Google sheets function with a comma.

Important Things To Note

We can combine text from two or more cells into one cell in Google sheets.
Some of the methods are, using ampersand symbol and functions like CONCATENATE, CONCAT, TEXTJOIN functions in Google sheets.
Remember, using CONCATENATE Google sheets function, we can combine data with a space or comma.

Frequently Asked Questions

1) Explain combine text from two or more cells into one single cell in Google sheets with a detailed example.

For example, consider the below table showing first name and last name in columns A and B, respectively.

Now, we need to combine the first name and last name in cells A2 and B2 in cell C2.

The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:C2. Next, we need to select the cell where we have to find the result. In this example, select the cell C2.
Step 2: Next, insert =A2&” “&B.
Step 3: Press Enter key.

We will be able to see the result in cell C2, as shown in the below image.

Likewise, we can combine text from two or more cells into one cell in Google sheets using the ampersand (&) symbol.

2) What is the syntax of CONCATENATE function in Google sheets?

The formula of CONCATENATE function in Google sheets is =CONCATENATE(string1,[string2],…) where string1 and string 2 shows the data to be combined in the cell.

3) What is the difference between CONCATENATE and CONCAT function in Google sheets?

Remember, CONCAT function in Google sheets combines data from only two cells. But Google sheets CONCATENATE function combines data from two or more cells.

Combine Text From Two Or More Cells Into One Cell In Google Sheets

What Is Combine Text From Two Or More Cells Into One Cell In Google Sheets?

Key Takeaways