Spreadsheet Practice

FIND function

Quick answer

FIND returns the position of one piece of text inside another, counting from 1.

Syntax
=FIND(find_text, within_text, [start_num])
Most common use
=FIND("@",A2) returns 10 (The position of the @)

On its own it's just a number, but paired with LEFT, MID or RIGHT it tells them where to cut. FIND is case-sensitive and has no wildcards; SEARCH is the forgiving version.

Available in
Every current version
Category
Text functions
Returns
A number: the position of the first character of the match, or #VALUE! if it isn't found.
Google Sheets
Works the same in Google Sheets.

Syntax

=FIND(find_text, within_text, [start_num])

ArgumentRequired?What it is
find_textRequiredThe text to look for.
within_textRequiredThe text to search in.
start_numOptionalPosition to start searching from. Leave it out to start at 1.

Examples

Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.

CellFormulaResultWhat it shows
D2=FIND("@",A2)10The position of the @
D3=FIND("-",B3,FIND("-",B3)+1)8The second dash: start searching just after the first
D4=LEFT(A4,FIND(".",A4)-1)leeThe first name: everything before the first dot

Try it live

This is the sample sheet. Change any number or text, or edit a formula, and the results update.

Show the sample data as a table
EmailOrder codeNoteResult
maya.chen@acme.comNY-2026-0142Ships Monday10
raj@globex.ioCA-2026-0187ships Tuesday8
lee.wong@initech.netTX-2025-0033Backorderlee

Practice FIND

From lesson 21, TEXTBEFORE, TEXTAFTER & FIND. Graded instantly, then re-checked on changed data.

The classic way

In D2, extract the username again using LEFT and FIND, the method that works in every Excel version. Fill down to D6.

Common mistakes

What you seeWhy, and how to fix it
#VALUE!FIND couldn't find the text, often because of case: FIND("ships",C2) misses "Ships". Use SEARCH for a case-insensitive match, or wrap FIND in IFERROR.
Wildcards don't workFIND treats * and ? as literal characters. Use SEARCH when you need wildcards.
Off by one when cuttingFIND returns the position of the delimiter itself. Subtract 1 to stop before it, or add 1 to start after it.

Tips

  • Test whether text contains something, with case: =ISNUMBER(FIND("VIP",A2)) returns TRUE or FALSE.

Questions

What is the difference between FIND and SEARCH in Excel?

FIND is case-sensitive and treats wildcards as plain characters. SEARCH ignores case and supports the ? and * wildcards. Both return #VALUE! when nothing is found.

How do I find the second occurrence of a character?

Start the second search one character after the first match: =FIND("-",A2,FIND("-",A2)+1).

Lessons that use FIND

Answers that use FIND

In other languages

FIND is ENCONTRAR in Spanish Excel and FINDEN in German Excel. Each page has the syntax with semicolons, the examples and the exercise in that language. For other functions and languages, use the Function Translator.

Updated Checked by running: every formula on this page was run by our formula engine on .