# JOIN function in Google Sheets

> JOIN combines the values in one or more rows or columns into a single piece of text, with a delimiter between each value.

Source: https://spreadsheetpractice.com/google-sheets/functions/join · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** JOIN combines the values in one or more rows or columns into a single piece of text, with a delimiter between each value.
- **Syntax:** `=JOIN(delimiter, value_or_array1, [value_or_array2, ...])`
- **Most common use:** `=JOIN(", ",A2:A6)` returns Ana, Raj, , Lee, Kim (JOIN keeps the blank in A4, so there is an empty slot between Raj and Lee)
- **Works in:** Google Sheets only
- **Returns:** Text: every value, joined with the delimiter between them.

## What it does

JOIN combines the values in one or more rows or columns into a single piece of text, with a delimiter between each value. Unlike TEXTJOIN it has no option to skip empty cells, so a blank cell leaves two delimiters side by side.

## Syntax

`=JOIN(delimiter, value_or_array1, [value_or_array2, ...])`

| Argument | Required? | What it is |
|---|---|---|
| `delimiter` | Required | The text to put between values, such as ", " or " \| ". Use "" for nothing. |
| `value_or_array1` | Required | A value, or a single row or column of cells, to join. Add more values or ranges as extra arguments. |

## Examples

Each result was calculated by running the formula on the sample sheet in Google Sheets mode.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| C2 | `=JOIN(", ",A2:A6)` | Ana, Raj, , Lee, Kim | JOIN keeps the blank in A4, so there is an empty slot between Raj and Lee |
| C3 | `=TEXTJOIN(", ",TRUE,A2:A6)` | Ana, Raj, Lee, Kim | For comparison: TEXTJOIN with TRUE skips the blank |
| C4 | `=JOIN("-",E2:G2)` | NY-2026-0142 | Joins a row of parts into one code: NY-2026-0142 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Name |  | Result |  | Region | Year | Number |
| 2 | Ana |  | Ana, Raj, , Lee, Kim |  | NY | 2026 | 0142 |
| 3 | Raj |  | Ana, Raj, Lee, Kim |  |  |  |  |
| 4 |  |  | NY-2026-0142 |  |  |  |  |
| 5 | Lee |  |  |  |  |  |  |
| 6 | Kim |  |  |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Doubled delimiters like "Raj, , Lee" | JOIN keeps empty cells. Use TEXTJOIN with TRUE to skip them: =TEXTJOIN(", ",TRUE,A2:A6). |
| An error when joining a block of cells | JOIN takes single rows or columns. For a block like A2:C5, use TEXTJOIN, or JOIN each row on its own. |
| Dates turn into numbers | JOIN uses the stored value, so a date shows up as a serial number. Format it first with TEXT, for example TEXT(A2,"mmm d"). |

## Tips

- JOIN accepts several arguments, so =JOIN(" ",B2,C2) joins two cells with a space, a short form of B2&" "&C2.
- If the list might have blanks, start with TEXTJOIN instead. It does everything JOIN does.

## JOIN in Excel

Excel has no JOIN. TEXTJOIN (Excel 2019 and later) does the same job and can skip blank cells, and it works in Google Sheets too.

## Questions

### What is the difference between JOIN and TEXTJOIN in Google Sheets?

TEXTJOIN has an ignore_empty argument, so it can skip blank cells. JOIN always includes them. Both put a delimiter between values.

### How do I combine a column into one cell with commas?

Use =JOIN(", ",A2:A10), or =TEXTJOIN(", ",TRUE,A2:A10) if the column has blanks.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
