Formualizer Docs
ReferenceFunctionsText Functions

TEXTJOIN

TEXTJOIN: Joins text values using a delimiter, with optional empty-value filtering.

Summary

TEXTJOIN(delimiter, ignore_empty, text1, ...) is useful for building labels and lists.

Remarks

  • ignore_empty=TRUE skips empty strings and empty cells.
  • ignore_empty=FALSE includes empty items, which can produce adjacent delimiters.
  • Delimiter and values are coerced to text.
  • Any error in inputs propagates immediately.

Examples

Ignore empty entries
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
a,c
Keep empty entries
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
a--c

FAQ

What does ignore_empty change?

TRUE skips empty values; FALSE keeps them, which can create adjacent delimiters.

Runtime metadata

Category

Text

Signature

TEXTJOIN(arg1, arg2, ... argN: Any)

This function accepts a repeating argument pattern (min args: 3).

Arity

min 3, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/trim_case_concat.rs

TEXTBEFORE

TEXTBEFORE: Returns text that appears before a delimiter.

TEXTSPLIT

TEXTSPLIT: Splits text into a dynamic 2D array by column and optional row delimiters.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does ignore_empty change?Runtime metadata