Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TEXTJOIN
TEXTJOIN concatenates all values in one or more ranges using a delimiter you specify, and can skip blank cells automatically. Use it to build comma-separated lists, create readable summaries from column data, or join tagged values without manual concatenation chains.
Excel
=TEXTJOIN(", ",TRUE,A2:A5)Google Sheets
=TEXTJOIN(", ",TRUE,A2:A5)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Choose your delimiter string (e.g., ", " for a comma-space separated list).
- 2Set the ignore_empty argument to TRUE to skip blank cells or FALSE to include them.
- 3Enter =TEXTJOIN(delimiter, ignore_empty, range) referencing the cells you want to combine.
Need a version for your data?
Try: “Create a comma-separated list of all product names from a column”