Google Sheets JOIN Function: Syntax, Examples, and Tips

How-to basics · Updated November 20, 2026

Google Sheets’ JOIN function combines text or values from cells and arrays into one text string, placing a delimiter between each item. Its basic form is =JOIN(delimiter, value_or_array1, [value_or_array2, ...]); for example, it can turn a list of names into a comma-separated line.

What the JOIN function does

JOIN is useful when separate spreadsheet values need to become one readable piece of text. A delimiter is the separator inserted between items. It can be a comma, space, slash, line-break character, or any other text you want. The function returns one value in the cell containing the formula; it does not combine cells physically or change the source data.

For instance, joining a first name and surname with a space produces a full name, while joining several product codes with a hyphen creates a single code string. Unlike a formula that simply places two cell references next to one another, JOIN can process a range and consistently add the chosen separator between its values.

The delimiter appears between items, not before the first item or after the last. If there is only one item to join, there is no separator to insert. The delimiter itself can contain more than one character, such as " | " with spaces around a vertical bar.

Syntax and arguments

The syntax is =JOIN(delimiter, value_or_array1, [value_or_array2, ...]). The first argument is required and specifies the separator. The next argument is also required and can be an individual value, a cell reference, or an array. Additional values or arrays are optional. In Google Sheets, separate function arguments with commas.

  • delimiter: Text inserted between items. Use an empty string, "", when you want to join values with no separator.
  • value_or_array1: The first value, range, or array to include.
  • Additional values or arrays: Optional items to append to the joined sequence. They can be cell references or other values.

A frequent source of confusion is the delimiter’s position in the formula. It must come first. In =JOIN("-", A2:A5), the hyphen is the delimiter and the range supplies the items. Reversing those arguments does not tell Sheets to use the range as a separator.

Join a range with a simple example

Suppose cells A2 through A4 contain the words North, Central, and South, one per cell. With those values in A2:A4, enter =JOIN(", ", A2:A4) in another cell. The result is North, Central, South. The comma and following space are repeated between the three values.

If the same range should be joined with a slash and spaces, use =JOIN(" / ", A2:A4). The result is North / Central / South. To concatenate the items directly, with no separator, use =JOIN("", A2:A4); the result is NorthCentralSouth. An empty delimiter is still a delimiter argument—it simply contributes no characters between items.

To combine values that are not in a single range, you can provide references as separate arguments. With a first name in A2 and a surname in B2, =JOIN(" ", A2, B2) returns a full name with one space between the two values. This is convenient when the parts of a result are in different columns or need to be combined with a fixed label.

Use a custom delimiter or add fixed text

The delimiter can be any text, not just punctuation. A space is helpful for names and addresses; commas suit lists; and a colon or slash can separate labels and values. Make the separator match the format expected by the next person or system that will use the result. For example, a comma-separated result may be easy to read but can be ambiguous if the individual values themselves contain commas.

Fixed text can also be supplied as an item. Suppose A2 contains a department name and B2 contains a team name. With those values in A2 and B2, =JOIN(" - ", A2, "Team", B2) inserts the fixed word “Team” into the sequence. If A2 contains Sales and B2 contains East, the result is Sales - Team - East. Because JOIN puts the delimiter between every item, it will also appear on both sides of the fixed word.

For a line break between joined values, Google Sheets supports the character function CHAR(10). With names in A2:A4, use =JOIN(CHAR(10), A2:A4). To display each joined item on its own line within the result cell, turn on text wrapping using Format > Wrapping > Wrap. Without wrapping, the line breaks may be less apparent in the cell. This is a display choice; the formula still returns a single cell value.

Blank cells and cleaning a list

Blank entries deserve attention when you build a delimited list from a range. Depending on the data and the way a range is supplied, empty entries can lead to separators with nothing visible between them. For example, a list with a blank between two filled cells may appear to contain doubled punctuation. If missing values should not appear in the output, filter them out deliberately rather than relying on how a blank is interpreted.

With the items in A2:A10, this formula filters out cells whose contents are empty before joining the remaining values: =JOIN(", ", FILTER(A2:A10, A2:A10<>"")). If A2:A4 contain red, a blank, and blue, the result is red, blue. The FILTER condition keeps only entries that are not equal to an empty string. If every cell is blank, FILTER has no matching rows and can return an error; you can decide whether that should be shown or handled separately.

Filtering empty cells is not the same as removing spaces from a value. A cell containing one or more spaces is not necessarily empty, so it may still be included. If source data may contain accidental spaces, clean it as a separate step or adjust the filtering condition to test the trimmed text. Check the original cells as well: a formula that returns an empty string can look blank even though the cell contains a formula.

Formatting numbers and dates in joined text

JOIN produces text, so consider how numbers, dates, and currency amounts should appear in the final string. A spreadsheet cell can display a date in a friendly format while the underlying value is a date serial number. When an exact presentation matters, explicitly format the value with TEXT before joining it.

For example, suppose A2 contains a project name and B2 contains a date. To display the date in year-month-day order, use =JOIN(" — ", A2, TEXT(B2, "yyyy-mm-dd")). If A2 is Launch and B2 is a date displayed as 2026-11-03 by that format, the result is Launch — 2026-11-03. The date format string controls the text produced by TEXT; choose a format appropriate for your audience and avoid assuming that the joined result will retain the source cell’s visual formatting.

The same principle applies to decimal places and currency symbols. Format the number as text first if the result must always show a specific number of decimals or a specific notation. This makes the intended output explicit, rather than relying on how a value happens to be displayed in its original cell.

JOIN compared with CONCATENATE and TEXTJOIN

Google Sheets offers several ways to combine text, but they have different jobs. JOIN is a good choice when a repeated delimiter should separate values in a range. CONCATENATE combines values in order, but it does not provide a delimiter argument that is automatically inserted between every item. You can include separators manually in a CONCATENATE formula, but that can become cumbersome for a long range.

CONCAT is another option for combining two values, but it is intended for a pair rather than as a delimiter-based range join. For multiple pieces with a separator and an option to ignore empty values, consider TEXTJOIN. Its syntax in Google Sheets is =TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...]). For example, with A2:A10 as the list, =TEXTJOIN(", ", TRUE, A2:A10) uses a comma and space and tells the function to ignore empty values. Choose JOIN for straightforward delimiter joining; choose TEXTJOIN when its empty-value option better matches the task.

Google Sheets and Excel have functions with similar names, but their available features and behavior can differ by application and version. This article describes Google Sheets in a web browser. If a workbook will be opened in Excel, confirm that the functions and formula behavior you rely on are supported there too.

Common problems and practical checks

If a formula produces an error or an unexpected string, check the input range, the delimiter, and the contents of the source cells. A delimiter entered in the wrong argument position is a common mistake. So is selecting a range that includes headings or unrelated cells. When the result contains doubled separators, inspect the range for empty-looking cells, formulas returning empty strings, and cells containing only spaces.

  • Unexpected extra punctuation: Check for blank entries or spaces in the source range, and filter values if blanks should be omitted.
  • Wrong date or number display: Use TEXT to specify the intended format before joining.
  • Missing spaces: Include the spaces in the delimiter, such as " - ", instead of assuming Sheets will add them.
  • Formula parse error: Confirm that parentheses and quotation marks are paired and that arguments are separated by commas.
  • Unexpected output order: JOIN uses the order of the supplied values. Sort or rearrange the source data first if a different order is needed.

Also remember that JOIN does not sort, deduplicate, or edit the original list. It combines the values in the order it receives them. If the output must be unique or alphabetized, prepare the input range using an appropriate Sheets function or sort the source data before joining.

When JOIN is useful

JOIN is handy for creating readable summaries, labels, and export-ready text from structured columns. Common uses include combining a person’s name parts, assembling a list of selected items, making a path from folder names, or building a short description from a category and detail. It can also combine values from a filtered range when a report needs a compact list rather than many separate rows.

Think about the destination before choosing a delimiter. A comma-separated list is compact, but a comma inside an item makes it harder to tell where one item ends and the next begins. A pipe, semicolon, or line break may be clearer. If another tool will import the result, follow that tool’s required format and consider whether values need escaping or quoting. JOIN inserts the delimiter; it does not automatically make a string into a properly escaped CSV record or validate it for another application.

Frequently Asked Questions

What is the formula for JOIN in Google Sheets?
Use =JOIN(delimiter, value_or_array1, [value_or_array2, ...]). Put the separator text first, followed by the cells, values, or arrays to combine.

How do I join cells with a comma and a space?
With the values in A2:A5, enter =JOIN(", ", A2:A5). The delimiter includes both the comma and the space, so the result reads as a conventional comma-separated list.

How do I join cells without anything between them?
Use an empty-string delimiter. With values in A2:A5, =JOIN("", A2:A5) joins them directly, without adding punctuation or spaces.

Does JOIN ignore blank cells?
Do not assume that blank-looking entries will be omitted in the way you want. If the output must exclude empty values, filter the range first or use TEXTJOIN with its ignore_empty argument set to TRUE.

What is the difference between JOIN and TEXTJOIN?
Both can combine values with a delimiter. TEXTJOIN includes an argument for whether empty values should be ignored, which makes it useful for lists with gaps. JOIN has a simpler delimiter-and-values structure.

Can JOIN combine values from separate cells?
Yes. Supply each reference as an argument after the delimiter, such as =JOIN(" ", A2, B2) for two name parts. Use a range argument when the values are in a continuous list.

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.