Formualizer Docs
ReferenceFunctionsText Functions

SEARCH

SEARCH: Returns the 1-based position of one text string inside another.

Summary

SEARCH is case-insensitive and supports * and ? wildcards.

Remarks

  • Search is case-insensitive.
  • * matches any sequence and ? matches a single character.
  • start_num is 1-based and must be greater than 0.
  • If no match is found, returns #VALUE!.

Examples

Case-insensitive search
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
7
Wildcard pattern
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
6

FAQ

How are case and wildcards handled?

SEARCH is case-insensitive and supports * for any sequence plus ? for one character.

Runtime metadata

Category

Text

Signature

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

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

Arity

min 2, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

RIGHT

Returns the rightmost characters from a text value.

SUBSTITUTE

SUBSTITUTE: Replaces matching text within a string.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are case and wildcards handled?Runtime metadata