Text · locate position · Nov 2026

The FIND function,
measured & explained.

Syntax, a live playground, a measured position gallery, the case-sensitivity and not-found traps, and a sourced error library: locating text by position.

D1
fx
=FIND("c", A2)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How FIND works

Returns the 1-based position of find_text in within_text. Case-sensitive; raises #VALUE! when not found.

=FIND(find_text, within_text, [start_num])
find_textThe text to locate (case-sensitive).
within_textThe string to search.
start_numOptional: where to begin; defaults to 1.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Locate text

What FIND actually returns

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.

Position gallery — case-sensitive, 1-based

ExpressionResultWhy
=FIND("c",A2)3Position of c in Excel
=FIND("E",A2)1Capital E is the first character
=FIND("e",A2)4Lowercase e sits at position 4
=FIND("o",A3)2Position of o in Formula
=FIND("Lookup",A4)1A whole substring is found at 1
=FIND("e",A2,2)4start_num 2 skips the first character
=FIND("z",A2)#VALUE!Not found raises #VALUE!
=IFERROR(FIND("z",A2),0)0Guard the not-found case with IFERROR

More positions

ExpressionResultWhy
=FIND("u",A4)5u is the fifth character of Lookup
=FIND("Lab",A5)1The whole cell matches at position 1
⚠ FIND is case-sensitive and returns #VALUE! when the text is not found — it never returns 0 or blank on its own. Use SEARCH for case-insensitive matching with wildcards, and wrap FIND in IFERROR to turn a miss into a safe default. FIND plus MID is the classic extract-between-markers pattern.
// 03 — Try it live

Interactive FIND playground

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.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where FIND works

FIND is available across modern Excel, Google Sheets and LibreOffice. It has been in Excel since 2003.

PlatformSupportNotesGotcha
✓ Supported full FIND◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master text search

FIND is one piece. The full course walks the toolkit end to end with live, measured examples.

  • FIND vs SEARCH — case and wildcards
  • The #VALUE! not-found trap and IFERROR
  • start_num for later occurrences
  • FIND + MID to extract between markers
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked