Text · search · Nov 2026

SEARCH.

Find where one string starts inside another — case ignored, wildcards honored, misses guarded. The face-off table shows exactly where SEARCH and FIND diverge, measured row by row.

D1
fx
=SEARCH(find, within)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How SEARCH works

Returns the 1-based position of the first match, or #VALUE! on a miss.

=SEARCH(find_text, within_text, [start_num])
find_textThe needle. ? and * act as wildcards; empty string returns 1.
within_textThe haystack to search inside.
start_num1-based position to start from; skips earlier matches. Must be 1..LEN(within_text).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
faceoff

SEARCH vs FIND — the measured face-off

Same inputs, two functions. SEARCH ignores case and honors wildcards; FIND is strict on both. Every row measured on the engine.

ExpressionResultWhy
=SEARCH("world","Hello World")7SEARCH: case ignored
=FIND("world","Hello World")#VALUE!FIND: case mismatch → error
=SEARCH("WORLD","Hello World")7SEARCH: uppercase also matches
=FIND("WORLD","Hello World")#VALUE!FIND: uppercase also fails
=FIND("World","Hello World")7FIND: exact case matches
=SEARCH("a?c","abc def")1SEARCH: ? is a wildcard
=FIND("a?c","abc def")#VALUE!FIND: ? is a literal character, no match
=SEARCH("o","Hello World",6)8start_num skips earlier matches
⚠ SEARCH treats ? and * as wildcards. If your needle literally contains a question mark or asterisk, SEARCH will mis-match — use FIND, or escape with ~? and ~*.
Default to SEARCH for human-entered text (case is noise). Use FIND when case is signal — passwords, codes, exact identifiers. Both return a 1-based position, and both raise #VALUE! on a miss: guard with IFERROR.
// 03 — Try it live

Interactive SEARCH playground

All presets are exact and engine-stable. Edit the grid strings and every gallery row recomputes live.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where SEARCH works

SEARCH is universal across Excel versions and Google Sheets with identical case and wildcard semantics.

PlatformSupportNotesGotcha
✓ Supported full SEARCH◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master text position

SEARCH is one piece. The full course walks the toolkit end to end with live, measured examples.

  • SEARCH vs FIND: case and wildcards
  • start_num and finding later matches
  • Guarding misses with IFERROR
  • Extracting with MID and LEN
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked