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.
Returns the 1-based position of the first match, or #VALUE! on a miss.
Same inputs, two functions. SEARCH ignores case and honors wildcards; FIND is strict on both. Every row measured on the engine.
| Expression | Result | Why |
|---|---|---|
| =SEARCH("world","Hello World") | 7 | SEARCH: case ignored |
| =FIND("world","Hello World") | #VALUE! | FIND: case mismatch → error |
| =SEARCH("WORLD","Hello World") | 7 | SEARCH: uppercase also matches |
| =FIND("WORLD","Hello World") | #VALUE! | FIND: uppercase also fails |
| =FIND("World","Hello World") | 7 | FIND: exact case matches |
| =SEARCH("a?c","abc def") | 1 | SEARCH: ? is a wildcard |
| =FIND("a?c","abc def") | #VALUE! | FIND: ? is a literal character, no match |
| =SEARCH("o","Hello World",6) | 8 | start_num skips earlier matches |
All presets are exact and engine-stable. Edit the grid strings and every gallery row recomputes live.
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.
SEARCH is universal across Excel versions and Google Sheets with identical case and wildcard semantics.
| Platform | Support | Notes | Gotcha |
|---|
SEARCH is one piece. The full course walks the toolkit end to end with live, measured examples.