Formualizer Docs
ReferenceFunctionsText Functions

TEXTAFTER

TEXTAFTER: Returns text that appears after a delimiter.

Summary

Returns text that appears after 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 after first delimiter
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
b-c
Text after last delimiter
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
c

FAQ

Is matching case-sensitive?

Yes. TEXTAFTER performs case-sensitive delimiter matching in this implementation.

Runtime metadata

Category

Text

Signature

TEXTAFTER(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

TEXT

Formats a value as text using a format pattern.

TEXTBEFORE

TEXTBEFORE: Returns text that appears before a delimiter.

On this page

SummaryRemarksExamplesRelated functionsFAQIs matching case-sensitive?Runtime metadata