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.
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.
Matching rules on the same text grid.
| Capability | FIND | SEARCH | Why it matters |
|---|---|---|---|
| Case-sensitive match | ✓ Exact case | ✗ Case-insensitive | FIND("excel") fails on "Excel"; SEARCH folds case. |
| * wildcard (any run) | ✗ Literal * | ✓ Any run | SEARCH("l*b") matches "lookup lab"; FIND fails. |
| ? wildcard (one char) | ✗ Literal ? | ✓ One char | SEARCH("H?llo") matches "Hello"; FIND fails. |
| Returns 1-based position | ✓ Position | ✓ Position | Both return 7 for "World" in "Hello World". |
| start_num skip-ahead | ✓ Supported | ✓ Supported | Same third argument; case changes which hit is first. |
| #VALUE! when absent | ✓ Errors | ✓ Errors | Wrap in IFERROR/ISNUMBER for a clean default. |
| Literal * / ? in needle | ✓ Treated literally | ✗ Treated as wildcard | Use FIND to match an actual asterisk character. |
Identical syntax; the difference is case and wildcards.
One editable text column, two locators. Pick a scenario or type your own — watch FIND error where SEARCH matches.
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.
=FIND("excel",B2)=SEARCH("excel",B2)=FIND("l*b",B3)=SEARCH("l*b",B3)=FIND("H?llo",B4)=SEARCH("H?llo",B4)=FIND("World",B4)=SEARCH("world",B4)=FIND("abc",B5)=SEARCH("ABC",B5)=FIND("xyz",B2)=SEARCH("xyz",B2)=FIND("e",B2,5)=SEARCH("e",B2,5)Engine cost locating a substring across a text stream (relative only, not Microsoft Excel).
| Table size | FIND | SEARCH |
|---|---|---|
| 1,000 rows × 200 lookups | 2.37 ms | 2.25 ms |
| 5,000 rows × 200 lookups | 2.49 ms | 1.34 ms |
| 10,000 rows × 200 lookups | 1.99 ms | 2.04 ms |
Pick by whether case and wildcards matter.
| Situation | Use | Why |
|---|---|---|
| Locate "excel" in "Excel Exercises" | SEARCH | FIND fails on case (#VALUE!); SEARCH returns 1. |
| Match a literal asterisk in a code | FIND | SEARCH would treat * as a wildcard. |
| Pattern H?llo (one unknown char) | SEARCH | FIND has no ? wildcard. |
| Exact-case product SKU position | FIND | Case-sensitive guarantees the right variant. |
| Case-insensitive contains check | SEARCH | Wrap in ISNUMBER(SEARCH(...)) for a boolean. |
| First "e" after position 5 | Either | FIND finds lowercase e at 9; SEARCH also matches uppercase E at 7. |
Common text-location tasks, side by side.
| Task | FIND / old way | SEARCH | What 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 validation | not 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. |