Formualizer Docs
ReferenceFunctionsText Functions

FIND

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

Summary

FIND is case-sensitive and does not interpret wildcard characters.

Remarks

  • Search is case-sensitive ("A" and "a" are different).
  • start_num is 1-based and must be greater than 0.
  • If no match is found, returns #VALUE!.
  • Errors in either argument are propagated.

Examples

Case-sensitive match
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
7
Case mismatch fails
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

Do wildcard characters work in FIND?

No. FIND treats * and ? as literal characters and matches case-sensitively.

Runtime metadata

Category

Text

Signature

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

EXACT

Compares two text values for exact equality.

FIXED

Formats a number as text with fixed decimal places.

On this page

SummaryRemarksExamplesRelated functionsFAQDo wildcard characters work in FIND?Runtime metadata