Text · Head-to-head

FIND vs SEARCH

Both return the position of one text inside another, and both share the same syntax. The difference is matching: FIND is case-sensitive and treats * and ? as literal characters; SEARCH is case-insensitive and treats them as wildcards. Below, the same needles are located by both, live.

fx
FIND(…)  vs  SEARCH(…)
#VALUE! / 1
FIND vs SEARCH("excel")
#VALUE! / 1
On wildcard l*b
9 vs 7
start_num=5 first "e"
7 / 7
Exact "World" found
▶ Try both live See the feature matrix
🏆Verdict: Match rule is the whole difference

FIND is case-sensitive with no wildcards; SEARCH is case-insensitive with * and ?. On 'Excel Exercises', FIND("excel",…) is #VALUE! while SEARCH returns 1; SEARCH("l*b","lookup lab") returns 1 while FIND treats l*b literally and fails.

FIND strengths

  • Matching a case-sensitive token (codes, IDs, passwords).
  • The needle contains literal * or ? characters.
  • You need an exact-case substring position.
  • Feeding MID/LEFT with a precise, case-aware offset.

SEARCH strengths

  • User-entered search where case varies.
  • Wildcard patterns like *lab* or H?llo.
  • Case-insensitive "contains" checks.
  • Finding a word regardless of capitalisation.

Feature-by-feature matrix

Matching rules on the same text grid.

CapabilityFINDSEARCHWhy it matters
Case-sensitive match✓ Exact case✗ Case-insensitiveFIND("excel") fails on "Excel"; SEARCH folds case.
* wildcard (any run)✗ Literal *✓ Any runSEARCH("l*b") matches "lookup lab"; FIND fails.
? wildcard (one char)✗ Literal ?✓ One charSEARCH("H?llo") matches "Hello"; FIND fails.
Returns 1-based position✓ Position✓ PositionBoth return 7 for "World" in "Hello World".
start_num skip-ahead✓ Supported✓ SupportedSame third argument; case changes which hit is first.
#VALUE! when absent✓ Errors✓ ErrorsWrap in IFERROR/ISNUMBER for a clean default.
Literal * / ? in needle✓ Treated literally✗ Treated as wildcardUse FIND to match an actual asterisk character.

Syntax, side by side

Identical syntax; the difference is case and wildcards.

FIND

FIND(find_text, within_text, [start_num])
find_textThe substring to locate (case-sensitive, no wildcards).
within_textThe text to search inside.
start_numOptional 1-based position to start from.
=FIND("World","Hello World") → 7

SEARCH

SEARCH(find_text, within_text, [start_num])
find_textThe substring or wildcard pattern (case-insensitive).
within_textThe text to search inside.
start_numOptional 1-based position to start from.
=SEARCH("hello","Hello World") → 1

Live head-to-head playground

One editable text column, two locators. Pick a scenario or type your own — watch FIND error where SEARCH matches.

A1Sample data — click any cell to edit; both formulas re-evaluate live

FIND

—

SEARCH

—
HyperFormula 3.5 · live

Every difference, measured

These are not feature-list claims. Each pair below was evaluated on the identical dataset in the HyperFormula 3.5 engine, and the outputs are baked from that run. Reproduce them in the playground above.

Case mismatch (lowercase needle in Title text)

Lowercase "excel" searched inside "Excel Exercises" — case mismatch.
FIND
=FIND("excel",B2)
#VALUE!
SEARCH
=SEARCH("excel",B2)
1
FIND("excel") is case-sensitive: lowercase "excel" is not in "Excel Exercises" → #VALUE!. SEARCH folds case → 1.

Star wildcard l*b

The pattern l*b against "lookup lab": wildcard vs literal asterisk.
FIND
=FIND("l*b",B3)
#VALUE!
SEARCH
=SEARCH("l*b",B3)
1
FIND treats l*b literally (no such substring) → #VALUE!. SEARCH reads * as any run → matches "lookup lab" at 1.

Question wildcard H?llo

The pattern H?llo against "Hello World": one-character wildcard.
FIND
=FIND("H?llo",B4)
#VALUE!
SEARCH
=SEARCH("H?llo",B4)
1
FIND treats H?llo literally → #VALUE!. SEARCH reads ? as one char → matches "Hello" at 1.

Exact substring found

An exact substring that exists, located by both functions.
FIND
=FIND("World",B4)
7
SEARCH
=SEARCH("world",B4)
7
When the exact substring exists, both agree: "World" starts at position 7.

Case-insensitive match

A literal match for FIND and a case-folded match for SEARCH.
FIND
=FIND("abc",B5)
1
SEARCH
=SEARCH("ABC",B5)
1
FIND("abc") matches literally at 1; SEARCH("ABC") folds case and also returns 1.

Substring absent

A substring that is absent — both return #VALUE!.
FIND
=FIND("xyz",B2)
#VALUE!
SEARCH
=SEARCH("xyz",B2)
#VALUE!
Absent substring: both return #VALUE!. Wrap in IFERROR/ISNUMBER for a clean default.

start_num=5 (case affects first hit)

start_num=5 skips ahead; case-insensitivity changes which hit is first.
FIND
=FIND("e",B2,5)
9
SEARCH
=SEARCH("e",B2,5)
7
From position 5, FIND finds the lowercase e at 9; SEARCH also matches the uppercase E at 7, so it returns 7. Case changes which hit is first.

Engine benchmark

Engine cost locating a substring across a text stream (relative only, not Microsoft Excel).

Table sizeFINDSEARCH
1,000 rows × 200 lookups2.37 ms2.25 ms
5,000 rows × 200 lookups2.49 ms1.34 ms
10,000 rows × 200 lookups1.99 ms2.04 ms
Measured in the HyperFormula 3.5 engine on this page, not in Microsoft Excel. Both locate a substring in one text value; absolute times are engine-specific and only meaningful as a relative signal.

Which one should you use?

Pick by whether case and wildcards matter.

SituationUseWhy
Locate "excel" in "Excel Exercises"SEARCHFIND fails on case (#VALUE!); SEARCH returns 1.
Match a literal asterisk in a codeFINDSEARCH would treat * as a wildcard.
Pattern H?llo (one unknown char)SEARCHFIND has no ? wildcard.
Exact-case product SKU positionFINDCase-sensitive guarantees the right variant.
Case-insensitive contains checkSEARCHWrap in ISNUMBER(SEARCH(...)) for a boolean.
First "e" after position 5EitherFIND finds lowercase e at 9; SEARCH also matches uppercase E at 7.

FIND → SEARCH migration

Common text-location tasks, side by side.

TaskFIND / old waySEARCHWhat changed
Contains check (forgiving)=ISNUMBER(FIND("lab",A2))=ISNUMBER(SEARCH("lab",A2))SEARCH ignores case; FIND requires exact case.
Extract after a delimiter=MID(A2,FIND("-",A2)+1,99)=MID(A2,SEARCH("-",A2)+1,99)Same result when the delimiter case is fixed.
One-char wildcard validationnot supported=ISNUMBER(SEARCH("H?llo",A2))Only SEARCH can express the ? wildcard.
Safe position default=IFERROR(FIND("x",A2),0)=IFERROR(SEARCH("x",A2),0)Both return #VALUE! when absent; IFERROR cleans it.

Frequently asked questions

What is the difference between FIND and SEARCH?
Both return the position of a substring. FIND is case-sensitive and does not support wildcards; SEARCH is case-insensitive and supports * and ?. Measured: FIND("excel","Excel Exercises")=#VALUE!, SEARCH=1.
Which one supports wildcards?
SEARCH. * matches any sequence of characters and ? matches exactly one. FIND treats both as literal characters (measured: FIND("l*b")=#VALUE!, SEARCH("l*b")=1).
Are FIND and SEARCH case-sensitive?
FIND is case-sensitive; SEARCH is case-insensitive. To make FIND forgiving, normalise both strings with LOWER, or just use SEARCH.
What do they return when the text is not found?
Both return #VALUE! (measured). Use IFERROR(FIND(...),0) or ISNUMBER(SEARCH(...)) to turn that into a usable default or boolean.
What does start_num do?
It skips ahead before matching, but the returned position is still absolute. Because SEARCH is case-insensitive it may find an earlier occurrence than FIND (measured from position 5: FIND=9, SEARCH=7).