Google Sheets: Combine Text From Two Cells

Google Sheets gives you three different ways to combine text from two or more cells, and most people only know one of them. The one they know is usually not the best choice for what they are doing. Understanding all three takes about five minutes and eliminates a specific category of formula frustration permanently.

This article contains affiliate links. If you buy through them, I may earn a small commission at no extra cost to you.

The first distinction to make is between combining cells and merging cells. These are different operations that get confused regularly. Combining cells using a formula creates a new cell that contains the text from two or more source cells, while the source cells remain unchanged. Merging cells using Format, Merge Cells in the menu physically joins the cells themselves, destroying all data except what was in the leftmost cell. For combining text content from multiple cells into one, always use a formula. The merge function is a display tool for headers and should not be used to consolidate data.

The Ampersand Operator

The ampersand (&) is the fastest way to combine text from two cells in Google Sheets. The syntax is =A1&B1, which joins whatever is in A1 and B1 with no separator between them. If A1 contains “John” and B1 contains “Smith,” the formula returns “JohnSmith” without a space. To add a space, you add a text string between the two references: =A1&” “&B1 returns “John Smith.”

The ampersand works with any number of cells and any combination of text strings, numbers, and cell references: =A1&”, “&B1&” “&C1 combines three cells with a comma after the first value. It handles numbers automatically, converting them to text without requiring an additional TEXT formula. The ampersand is the right choice when you are combining two to four cells and want direct control over the separator for each join point.

CONCAT Function

CONCAT is the simplest function syntax: =CONCAT(A1,B1). It joins exactly two values with no separator. If you need to add a separator or combine more than two cells, CONCAT requires you to nest functions or chain multiple CONCATs. =CONCAT(CONCAT(A1,” “),B1) adds a space between A1 and B1 using nested functions, which is less readable than the ampersand equivalent =A1&” “&B1. CONCAT is most useful when you are concatenating exactly two cells with no separator, or when you are teaching the concept and want the function name to make the operation explicit.

CONCATENATE Function

CONCATENATE accepts multiple arguments and combines them in sequence: =CONCATENATE(A1,” “,B1) combines A1, a space, and B1 in a single function call. It is more readable than nested CONCAT and more explicit than the ampersand operator, which makes it easier to audit in complex formulas. The syntax for combining three cells with a comma separator: =CONCATENATE(A1,”, “,B1,”, “,C1). CONCATENATE is the right choice when you are combining more than two cells and want the formula to be self-documenting for collaborators who might edit it later.

TEXTJOIN: The Best Option for Multiple Cells

TEXTJOIN is the most useful text-combining function for combining many cells and is underused because it is less well-known than CONCATENATE. The syntax: =TEXTJOIN(“, “,TRUE,A1:A10). The first argument is the separator to use between each value. The second argument is whether to ignore empty cells (TRUE ignores them, FALSE includes blank entries which results in double separators). The third argument is the range or list of values to combine.

TEXTJOIN is the correct choice when you need to combine a variable-length list of cells into one value, combine a range that might contain empty cells, or produce a clean separator-delimited list from a column of data. =TEXTJOIN(“, “,TRUE,A1:A50) combines up to 50 cells, skips any that are empty, and puts a comma and space between each value. The equivalent formula using CONCATENATE or ampersand would require you to handle each cell reference individually.

The practical scenarios where each function wins: use the ampersand for quick two-to-four-cell joins in formulas you write quickly. Use CONCATENATE when the formula will be maintained by others and readability matters. Use TEXTJOIN when combining a column range or any list where some cells may be empty. Avoid Format, Merge Cells entirely when the goal is to consolidate data, because it destroys the source data in all but the leftmost cell.

For building this into a larger Google Sheets workflow, the Google Sheets calendar guide covers how to use formulas like these in a practical planning tool. For connecting Google Sheets data to automated email campaigns, the mail merge guide shows how combined text fields feed directly into email personalization. For the broader toolkit of free tools that include Google Sheets, the 2026 free tool stack is the reference. For automating what happens when Google Sheets data changes, Make.com can watch specific cells or columns for updates and trigger downstream actions automatically.