Syntax, a live playground, a measured position gallery, the case-sensitivity and not-found traps, and a sourced error library: locating text by position.
Returns the 1-based position of find_text in within_text. Case-sensitive; raises #VALUE! when not found.
FIND returns the 1-based position of one text inside another. It is case-sensitive and raises #VALUE! when the text is absent. Every row was measured live in HyperFormula. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =FIND("c",A2) | 3 | Position of c in Excel |
| =FIND("E",A2) | 1 | Capital E is the first character |
| =FIND("e",A2) | 4 | Lowercase e sits at position 4 |
| =FIND("o",A3) | 2 | Position of o in Formula |
| =FIND("Lookup",A4) | 1 | A whole substring is found at 1 |
| =FIND("e",A2,2) | 4 | start_num 2 skips the first character |
| =FIND("z",A2) | #VALUE! | Not found raises #VALUE! |
| =IFERROR(FIND("z",A2),0) | 0 | Guard the not-found case with IFERROR |
| Expression | Result | Why |
|---|---|---|
| =FIND("u",A4) | 5 | u is the fifth character of Lookup |
| =FIND("Lab",A5) | 1 | The whole cell matches at position 1 |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to see FIND locate characters by case, skip ahead with start_num, and guard a miss with IFERROR.
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.
FIND is available across modern Excel, Google Sheets and LibreOffice. It has been in Excel since 2003.
| Platform | Support | Notes | Gotcha |
|---|
FIND is one piece. The full course walks the toolkit end to end with live, measured examples.