Combine text from multiple cells or ranges with a delimiter between each item.
TEXTJOIN works the same in Google Sheets, and pairs naturally with ARRAYFORMULA for whole-column joins.
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)TEXTJOIN concatenates a range of values and inserts a delimiter — a comma, space, or line break — between them, optionally skipping blanks. It's far cleaner than chaining CONCAT or & for lists. Available in Microsoft 365 and Excel 2019+.
=TEXTJOIN(", ", TRUE, A2:A6)Result: Mon, Tue, Wed, Fri
Joins the list with commas and skips the empty cell.
TEXTJOIN adds a delimiter between items and can skip blanks; CONCAT simply glues values together with no separator.