Formualizer Docs
ReferenceFunctionsText Functions

SEARCHB

SEARCHB: Searches text using non-DBCS byte-compatible semantics.

Summary

In Formualizer's invariant locale, SEARCHB delegates to SEARCH and supports the same wildcard behavior.

Examples

Wildcard byte-compatible search
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
4

FAQ

Is SEARCHB case-sensitive?

No. It follows SEARCH behavior in the invariant locale.

Runtime metadata

Category

Text

Signature

SEARCHB(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/byte.rs

SEARCH

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

SUBSTITUTE

SUBSTITUTE: Replaces matching text within a string.

On this page

SummaryExamplesRelated functionsFAQIs SEARCHB case-sensitive?Runtime metadata