How to Combine Text From Two Cells in Google Sheets: A Step-by-Step Guide

Published: February 10, 2024 - 4 min read

Julian Alvarado

Merging text from two cells in Google Sheets is a common task, especially when dealing with names, addresses, or any data spread across columns. 

This guide will show you how to seamlessly combine text, ensuring your data is presented clearly. You’ll learn to use simple functions and operators, transforming your data management experience.

Basic Methods for Combining Text

When working with Google Sheets, it is often necessary to combine text from two different cells. This can be useful when you have a first name and last name in separate columns, and you want to combine them into one column. 

In this section, we will explore some basic methods for combining text in Google Sheets.

Using Ampersand (&) Operator

One of the simplest ways to combine text in Google Sheets is to use the ampersand (&) operator. This operator allows you to join two or more strings of text together. T

o use the ampersand operator, simply type an ampersand between the two cells that you want to combine.

For example, if you have the first name in cell A1 and the last name in cell B1, you can combine them using the following formula:

=A1&” “&B1

This formula will join the text in cell A1 with a space and the text in cell B1, resulting in a full name in one cell.

Utilizing the CONCATENATE Function

Another way to combine text in Google Sheets is to use the CONCATENATE function. 

This function allows you to join two or more strings of text together, just like the ampersand operator. However, it can be more useful when you need to combine more than two cells.

To use the CONCATENATE function, simply type the function name followed by the cells that you want to combine. For example, if you have the first name in cell A1 and the last name in cell B1, you can combine them using the following formula:

=CONCATENATE(A1,” “,B1)

This formula will join the text in cell A1 with a space and the text in cell B1, resulting in a full name in one cell.

Leveraging the CONCAT Function

The CONCAT function is another way to combine text in Google Sheets. This function is similar to the CONCATENATE function, but it allows you to combine text from multiple cells into one cell with less typing.

To use the CONCAT function, simply type the function name followed by the cells that you want to combine. For example, if you have the first name in cell A1 and the last name in cell B1, you can combine them using the following formula:

=CONCAT(A1,” “,B1)

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 314,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

This formula will join the text in cell A1 with a space and the text in cell B1, resulting in a full name in one cell.

Advanced Techniques

Applying TEXTJOIN Function

The TEXTJOIN function is an advanced technique that lets you combine text from multiple cells with a specified delimiter. It is similar to the CONCATENATE function, but it offers more flexibility. With TEXTJOIN, you can specify a delimiter that separates the text in the resulting string.

Here is an example of how to use the TEXTJOIN function in Google Sheets:

=TEXTJOIN(“,”, TRUE, A1:A5)

This formula combines the text in cells A1 through A5 with a comma delimiter. The second argument, TRUE, tells the function to ignore empty cells. You can change the delimiter to any character you want, such as a space, hyphen, or semicolon.

Creating Custom Formulas with Functions

Google Sheets allows you to create custom formulas with functions. This is a powerful feature that lets you automate complex tasks and save time. 

For example, you can create a custom formula that combines text from two cells and formats the result in a specific way.

Here is an example of how to create a custom formula in Google Sheets:

  1. Click on Tools in the menu bar and select Script editor.
  2. In the script editor, create a new function and give it a name, such as combineText.
  3. Write the code for the function, such as return cell1 + ” ” + cell2; to combine the text in two cells with a space delimiter.
  4. Save the function and close the script editor.
  5. In your Google Sheet, enter the formula =combineText(A1,B1) to use the custom function.

You can create custom formulas with any combination of functions and operators. This gives you complete control over the formatting and manipulation of your data.

Conclusion

Combining text in Google Sheets is straightforward with these methods. Whether you prefer a quick fix or a custom solution, these techniques have you covered.

Ready to boost your Google Sheets skills further? Discover Coefficient for advanced data integration solutions. Start with Coefficient.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies