Function reference /Text

TEXTJOIN

Run in a real sheet

Joins text from several cells into one, separated by a delimiter of your choice.

TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])

TEXTJOIN is CONCATENATE with the two things CONCATENATE lacks: a separator applied automatically between items, and the option to skip blanks so you do not end up with stray commas.

Executed 23 Aug 2026 Google Sheets · unedited screenshot
=TEXTJOIN(", ", TRUE, B2:B6) running in Google Sheets, returning Ana, Ben, Cara, Dan, Eve
The formula sits in the formula bar and its answer sits in the grid, in one frame. Every rep's name in one cell, comma separated.

Worked example

RegionRepSales
WestAna1200
EastBen900
WestCara1500
NorthDan600
EastEve1100
 
=TEXTJOIN(", ", TRUE, B2:B6)

Returns Ana, Ben, Cara, Dan, Eve.

Arguments

ArgumentRequiredWhat it does
delimiter Yes What to put between items — ", " for a comma-separated list.
ignore_empty Yes TRUE skips blank cells. FALSE leaves a gap for each one.
text1 Yes The cells or ranges to join.

Gotchas

  • 01Passing FALSE for ignore_empty on a range with blanks produces runs of delimiters like "Ana, , Cara".
  • 02A cell containing a formula that returns "" is not empty and is not skipped.
  • 03The result is capped at the cell character limit; very large ranges get truncated.