Home/Formulas/Text/TEXTJOIN
Texteasy

TEXTJOIN()

Combines text with a delimiter, optionally skipping empty cells.

Syntax
fx
=TEXTJOIN(delimiter, ignore_empty, text1, ...)
Try it
F2
→
Q1, Q2, Q3, Q4
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • The 2nd arg ignore_empty matters: with TRUE, the delimiter is NOT inserted between empty cells, avoiding double-delimiters like "a, , b".
  • Concatenates very long ranges into one cell: Sheets caps cells at 50,000 characters; large inputs may silently truncate.
  • Outputs as a string; TEXTJOIN(",", TRUE, 1, 2, 3) + 0 won't coerce back to numbers.
Related formulas
CONCATENATE()
Appends strings to one another.
SPLIT()
Divides text around a specified character or string.
Used by
CONCATENATE()
Appends strings to one another.
SPLIT()
Divides text around a specified character or string.
More Text formulas →Keyboard shortcuts for Sheets →