Formula guide · Excel and Google Sheets · Updated May 13, 2026
TEXTJOIN Examples
Use TEXTJOIN to combine names, tags, IDs, or values with a delimiter.
Quick Answer
TEXTJOIN combines many values and can skip blanks automatically.
Copyable Formula
=TEXTJOIN(", ",TRUE,A2:C2)Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)Excel and Google Sheets
Worked Example
| A | B | C |
|---|---|---|
| First | Middle | Last |
| Maya | Chen |
Result: Returns Maya, Chen because the blank middle cell is ignored.
Steps
- Choose the delimiter, such as comma-space.
- Use TRUE to ignore empty cells.
- Select the range or cells to combine.
Common Mistakes
- Using CONCAT when a delimiter is needed.
- Forgetting to set ignore_empty to TRUE.
- Joining too many values into a result that becomes hard to read.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.