Google Sheets Join Text in Cells: Formulas, Tips, and Fixes

How-to basics · Updated November 20, 2026

Yes. To join text from cells in Google Sheets, use the ampersand operator (&), or use functions such as TEXTJOIN when you need a separator or want to skip blank cells. For example, if A2 contains “Ada” and B2 contains “Lovelace,” enter =A2&" "&B2 in another cell to return Ada Lovelace.

What joining text means in Sheets

Joining, combining, or concatenating text means putting values from two or more cells together in one result. The original cells remain unchanged: the result appears in the cell containing the formula. You can combine names, addresses, product codes, labels, notes, or other text, and you can insert punctuation or spaces between values.

This is different from merging cells. The Merge cells command changes the layout of the selected cells and does not combine all their contents into one text string. If you want a single text result, use a formula instead. This distinction matters because merging can discard content in cells other than the upper-left cell, whereas a joining formula can include each source cell’s value.

A formula result usually updates when its source cells change. That makes formulas useful for lists and records that are still being edited. If you need a fixed result that will no longer update, copy the formula result and use Edit > Paste special > Values only to replace it with its current value.

Use the ampersand for a quick combination

The ampersand is often the simplest choice for a few cells. It joins the items on either side of it, and you can add a quoted string to supply a space, comma, dash, or other separator. Text in quotation marks is treated as a literal value; cell references are read from the referenced cells.

With “Ada” in A2 and “Lovelace” in B2, enter =A2&" "&B2 in C2. The result is Ada Lovelace. The middle part, " ", is one space. If you leave it out, the result is AdaLovelace with no gap.

With a city in A2 and a region in B2, such as “Portland” and “Oregon,” enter =A2&", "&B2 in C2. The result is Portland, Oregon. You can build longer expressions by adding more references and literal strings. For example, place a street address in A2, a city in B2, and a postal code in C2, then join the pieces with commas or spaces as needed.

The ampersand is convenient when each component needs its own punctuation or when there are only a few components. For a long range of cells, a function with a delimiter is usually easier to read and maintain.

Choose between CONCATENATE, CONCAT, JOIN, and TEXTJOIN

Google Sheets offers several ways to combine values. The best option depends on whether you need a delimiter, are combining a range, or want empty cells omitted.

  • & joins individual references and text strings. It is concise and flexible for a short expression.
  • CONCATENATE combines two or more strings in order. It does not add spaces or punctuation automatically, so include those as arguments.
  • CONCAT combines two values without a separator. It is useful for a simple pair, but does not provide the multiple-cell convenience of a delimiter-based formula.
  • JOIN combines the elements of an array or range using one delimiter. It is useful when every item should be separated in the same way.
  • TEXTJOIN combines text with a chosen delimiter and lets you tell Sheets whether to ignore empty values. It is often the most convenient option for a range that may contain blanks.

These functions do not insert a separator unless the function’s arguments or formula explicitly specify one. For instance, CONCATENATE can combine first and last names, but a space must be supplied between them. Google Sheets also supports the CONCATENATE function for compatibility with spreadsheets that use that function name.

Join a range with JOIN or TEXTJOIN

Use JOIN when you want the same delimiter between the values in a range and do not need the function to skip blanks. With the words red, blue, and green in A2:A4, enter =JOIN(", ",A2:A4) in B2. The result is red, blue, green. The first argument is the delimiter; the second is the range to combine.

Use TEXTJOIN when blank cells may occur or when you want the option to ignore them. With Ada in A2, an empty A3, and Lovelace in A4, enter =TEXTJOIN(" ",TRUE,A2:A4) in B2. The result is Ada Lovelace. Here, the space is the delimiter, and TRUE tells Sheets to ignore empty cells.

If you want empty cells included in the joining process, set the second argument to FALSE. With Ada in A2, a blank A3, and Lovelace in A4, =TEXTJOIN(" ",FALSE,A2:A4) in B2 includes a separator for the blank position, so the visible result has an extra space between the two names. This difference can be hard to notice in a cell, but it may matter when the output is exported or used in another formula.

A delimiter can be a space, comma, semicolon, slash, line break, or any other text. For example, a comma-and-space delimiter is useful for a readable list, while a hyphen may suit a code made from separate parts. When joining a range, check that the delimiter is appropriate for every item; Sheets applies the same delimiter between each included element.

Combine text with numbers, dates, and formatting

Cells can display numbers as dates, percentages, or currency, but a formula that joins a cell may use its underlying value rather than the exact visual formatting shown in the cell. As a result, combining a date or formatted number directly with text may not produce the appearance you expect. Use the TEXT function to specify how a number should appear in the joined result.

With the date January 5, 2026, in A2, enter ="Due: "&TEXT(A2,"mmm d, yyyy") in B2. The result is Due: Jan 5, 2026. The format pattern controls the text representation, so patterns such as yyyy-mm-dd can be useful when a consistent date layout is important.

With a description in A2 and the decimal value 0.125 in B2, enter =A2&" ("&TEXT(B2,"0.0%")&")" in C2. If A2 contains “completion,” the result is completion (12.5%). The percentage pattern displays the decimal as a percentage with one decimal place. Choose a pattern that fits your data and intended output.

Formatting with TEXT changes the joined result into text; it does not change the original numeric cell. Keep the source value as a number if you still need to calculate with it. A separate result column can show the formatted label while leaving the original date or amount available for sorting, calculations, and charts.

Join text across rows or columns

A range supplied to JOIN or TEXTJOIN can make it easier to combine a list without typing every cell reference. For a vertical range such as A2:A20, put the formula in a separate cell outside that range. You can also use a horizontal range, such as A2:D2, to combine items arranged across one row.

For example, with tags in A2:D2, enter =TEXTJOIN(" | ",TRUE,A2:D2) in E2. The result places a vertical bar between nonempty tags, such as urgent | invoice | review. If you copy the formula down for additional records, adjust the referenced row as needed. Relative references normally shift when a formula is copied; use dollar signs in a reference if you need to keep a row or column fixed.

When joining a large range, consider whether the output is meant to be one readable label or a data format for another system. A comma-separated string may be easy to read, but if the values themselves can contain commas, the result can be ambiguous when imported elsewhere. A delimiter that does not appear in the source data, or a proper export method, may be more suitable for that use.

Common problems and how to fix them

  • No spaces between words: Joining functions and the ampersand do not add spaces by default. Include a space delimiter, such as " ", or choose that delimiter in JOIN or TEXTJOIN.
  • Unexpected blank gaps: Use TEXTJOIN with TRUE as its ignore-empty argument if blank cells should not contribute separators. Remember that a cell containing a formula that returns an empty string may behave differently from a truly empty cell in some situations; inspect the source formulas if a gap remains.
  • A date or number looks different: Use TEXT to specify the display pattern before joining the value with other text.
  • The formula appears as text: Check that the cell is not formatted as plain text and that the entry begins with an equals sign. Re-enter the formula after changing the cell’s format if needed.
  • Formula parse error: Check parentheses, quotation marks, and commas. Spreadsheet locale settings can affect formula argument separators; if Sheets expects semicolons in your locale, use the separator indicated by the editor.
  • The result is in the wrong place: Put the formula in a cell outside the source range so the formula does not overwrite an input cell.

When a formula result will be reused elsewhere, test it with a row containing a blank, punctuation, and the kinds of numbers or dates present in the real data. That small check can reveal awkward separators or formatting surprises before you fill the formula down a long sheet.

Google Sheets compared with Excel

The ampersand operator, CONCATENATE, CONCAT, and TEXTJOIN are also available in modern versions of Excel, though availability can depend on the Excel version for newer functions. Google Sheets additionally has a JOIN function with the delimiter-and-array pattern shown above; Excel does not use a function named JOIN for this task. In Excel, TEXTJOIN is the closest equivalent for joining a range with a delimiter and an option to ignore empty cells.

Both programs use formulas for combining text, but menus and some version-specific features differ. The examples here are for Google Sheets in a web browser; enter them directly into a cell or the formula bar. If a workbook is opened in Excel, check the formula there rather than assuming that every function name or interface option behaves identically.

Frequently Asked Questions

How do I join two cells in Google Sheets with a space?
Put =A1&" "&B1 in an empty cell, replacing A1 and B1 with your cell references. The quoted space supplies the gap; without it, the values run together.

How do I combine multiple cells and skip blanks?
Use TEXTJOIN with TRUE as its second argument, followed by the range. For example, =TEXTJOIN(", ",TRUE,A2:A10) joins the nonempty cells with comma-space separators.

Can I join cells without a formula?
You can copy and paste values into a cell, but that does not create a result that updates when source cells change. For a dynamic combined result, use a formula. You can later paste the result as values if you need a fixed snapshot.

Does merging cells combine their text?
No. Merging changes the cell layout; it is not the same as joining text. Use a formula such as & or TEXTJOIN when the goal is to preserve and combine values from multiple cells.

How can I add a line break between joined values?
Use CHAR(10) as the delimiter in TEXTJOIN, for example =TEXTJOIN(CHAR(10),TRUE,A2:A5). Turn on text wrapping for the result cell so the separate lines can display inside the cell.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.