# How to combine a column into one cell with commas in Google Sheets

Use TEXTJOIN with TRUE to skip blanks: `=TEXTJOIN("; ",TRUE,B2:B8)` joins the emails into one line you can paste into the To field.

**Google Sheets:** `=TEXTJOIN("; ",TRUE,B2:B8)`

**Excel:** The same TEXTJOIN formula works in Excel 2019 and later.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Name | Email |  | To line |
| Ana Ruiz | ana@ruiz.example |  |  |
| Raj Patel | raj@patel.example |  |  |
| Lee Chen |  |  |  |
| Kim Ortiz | kim@ortiz.example |  |  |
| Mo Diaz | mo@diaz.example |  |  |
| Sam Cole | sam@cole.example |  |  |
| Eve Lund | eve@lund.example |  |  |

Formula in D2: `=TEXTJOIN("; ",TRUE,B2:B8)`

Result: ana@ruiz.example; raj@patel.example; kim@ortiz.example; mo@diaz.example; sam@cole.example; eve@lund.example

## How it works

TEXTJOIN takes the separator, whether to ignore empty cells, and the range. With TRUE, Lee Chen's missing email is skipped instead of leaving "; ;" in the middle. The result updates when an address is added or changed.

## Other ways

- `=JOIN("; ",B2:B8)`: JOIN is Sheets' older function. It has no option to skip blanks. (Has an empty slot, "; ;", where Lee Chen's email is missing.)

## Common mistakes

- TEXTJOIN returns an error if the result is longer than 50,000 characters, the most a cell can hold.
- Numbers keep their underlying value: a date joins as 46174. Format first with TEXT.

## Questions

**How do I join only the rows that match a condition?**

Filter first: `=TEXTJOIN(", ",TRUE,FILTER(A2:A8,B2:B8<>""))`.

**How do I put each item on its own line in the cell?**

Use CHAR(10) as the separator and turn on text wrapping: `=TEXTJOIN(CHAR(10),TRUE,A2:A8)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/combine-a-column-into-one-cell-in-google-sheets