deepcalc
DocsTEXTJOIN

TEXTJOIN

View as markdown/docs/functions/textjoin.md Ask Claude about this pageOpens Claude with this page's address

Joins text with delimiter, ignoring blanks.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Text

Examples

=TEXTJOIN(", ", TRUE, A1:A3)
A
1 10
2 20
3 30
Result 10, 20, 30

Syntax

TEXTJOIN(delimiter, ignore_empty, text…)
delimiter
text required
ignore_empty
boolean required
text…
any required
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.