Formualizer Docs
ReferenceFunctionsText Functions

TEXTBEFORE

TEXTBEFORE: Returns text that appears before a delimiter.

Summary

Returns text that appears before a delimiter.

Remarks

  • Delimiter matching is case-sensitive.
  • instance_num defaults to 1; negative instances search from the end.
  • instance_num=0 or empty delimiter returns #VALUE!.
  • If requested delimiter occurrence is not found, returns #N/A.

Examples

Text before first delimiter
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
a
Text before last delimiter
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
a-b

FAQ

What happens when the delimiter is missing?

TEXTBEFORE returns #N/A when the requested delimiter occurrence is not found.

Runtime metadata

Category

Text

Signature

TEXTBEFORE(arg1: Any, arg2: Any, arg3?: Number)

Arity

min 2, max 3

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

arg3optionaldefault

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

TEXTAFTER

TEXTAFTER: Returns text that appears after a delimiter.

TEXTJOIN

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens when the delimiter is missing?Runtime metadata