Formualizer Docs
ReferenceFunctionsText Functions

TEXTSPLIT

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

Summary

TEXTSPLIT supports multiple delimiters, optional case-insensitive matching, and output padding.

Remarks

  • Column delimiter is required; row delimiter is optional.
  • match_mode=0 is case-sensitive, match_mode=1 is case-insensitive.
  • ignore_empty=TRUE drops empty segments created by adjacent delimiters.
  • Rows are padded to equal width using pad_with (default #N/A).

Examples

Split CSV row
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
{A,B,C}
Row and column split with padding
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
{A,B;C,#N/A}

FAQ

Is delimiter matching case-sensitive?

Yes by default; set match_mode to 1 for case-insensitive delimiter matching.

Runtime metadata

Category

Text

Signature

TEXTSPLIT(arg1: Any, arg2: Any, arg3?: Any, arg4?: Logical, arg5?: Number, arg6?: Any)

Arity

min 2, max 6

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

arg3optional

Any · Scalar

arg4optionaldefault

Logical · Scalar · coercion Logical

arg5optionaldefault

Number · Scalar · coercion NumberLenientText

arg6optionaldefault

Any · Scalar

Caps

PURE

Source

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

TEXTJOIN

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

TRIM

TRIM: Removes leading/trailing whitespace and collapses internal runs to single spaces.

On this page

SummaryRemarksExamplesRelated functionsFAQIs delimiter matching case-sensitive?Runtime metadata