Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
JOIN
JOIN combines values from a range or array into a single text string, inserting a chosen delimiter between each value. It is the Google Sheets counterpart to TEXTJOIN and is frequently used to build comma-separated lists, construct sentences from data, or merge codes.
Excel
=A2&", "&A3&", "&A4Google Sheets
=JOIN(", ",A2:A5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| City | Combined |
| Paris | Paris, London, Tokyo, Berlin |
| London | |
| Tokyo | |
| Berlin |
=A2&", "&A3&", "&A4→Paris, London, Tokyo
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
- 1Select the cell where you want the combined string to appear.
- 2Enter =JOIN(", ",A2:A5) to join all values in A2:A5 with a comma-and-space delimiter.
- 3Change the delimiter to any string (e.g., " | " or "-") to suit your output format.
Need a version for your data?
Try: “Combine a list of city names into a single comma-separated string”