Google Sheets reference

TEXTJOIN in Google Sheets

Works in Google Sheets2 worked examples

Worked examples (2)

These formulas work in Google Sheets with identical syntax.

Text Manipulationbeginner

=TEXTJOIN(", ",TRUE,A2:A20)

Text Manipulationbeginner

=TEXTJOIN(" ",TRUE,A2:C2)

Also in Excel

See the full TEXTJOIN reference for Excel — including all worked examples, common errors, and FAQ.