# FIND vs SEARCH in Excel

> Both return the position of text inside other text. FIND is case-sensitive and takes the text literally; SEARCH ignores case.

Source: https://spreadsheetpractice.com/functions/compare/find-vs-search · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

Both return the position of text inside other text. FIND is case-sensitive and takes the text literally; SEARCH ignores case. Use SEARCH unless capital letters matter to the answer.

## The differences

|  | FIND | SEARCH |
|---|---|---|
| Case | Case-sensitive: "abc" won't find "ABC" | Ignores case |
| Wildcards (? and *) | Not supported | Supported |
| Not found | #VALUE! | #VALUE! |
| Available in | Every version | Every version |

## Same data, side by side

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=FIND("ABC",A2)` | #VALUE! | FIND is case-sensitive, so "ABC" isn't found: #VALUE! error |
| D3 | `=SEARCH("ABC",A2)` | 5 | SEARCH ignores case and finds it at position 5 |
| D4 | `=ISNUMBER(SEARCH("abc",A2))` | TRUE | The usual "contains" test: TRUE or FALSE, no error |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Order code |  | Question | Result |
| 2 | ORD-abc-2291 |  | FIND "ABC" | #VALUE! |
| 3 |  |  | SEARCH "ABC" | 5 |
| 4 |  |  | Has "abc"? | TRUE |

## When to use each

### Choose FIND when

Case matters, such as codes where "a" and "A" mean different things.

### Choose SEARCH when

You want a "contains" test that works however the text is capitalized.

## The functions

- [FIND](https://spreadsheetpractice.com/functions/find): FIND returns the position of one piece of text inside another, counting from 1. Every current version.
- [SEARCH](https://spreadsheetpractice.com/functions/search): SEARCH returns the position of one piece of text inside another, ignoring upper and lower case, and it understands the ? and * wildcards. Every current version.

## Questions

### How do I check if a cell contains text?

Use =ISNUMBER(SEARCH("text",A2)). It returns TRUE when the text appears anywhere and FALSE otherwise.

### Why does FIND return #VALUE!?

The text isn't there exactly as typed, often because of capitalization. Try SEARCH, which ignores case.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
