FUNCTION CATALOGUE / TEXT
TEXTJOIN Excel function
Joins text using a delimiter.
Correct sentence to use
Join [range] using [delimiter], ignoring empty cells.
Modify this query in PlainFormula →Example formula
=TEXTJOIN(", ",TRUE,A2:A20)
Combines text with a delimiter.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Argument signature: delimiter, ignore_empty, text1, [text2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.