# FIND function in Excel

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

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

## Quick answer

- **What it does:** 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 @)
- **Available in:** Every current version
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **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.

## What it does

FIND returns the position of one piece of text inside another, counting from 1. 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.

## Syntax

`=FIND(find_text, within_text, [start_num])`

| Argument | Required? | What it is |
|---|---|---|
| `find_text` | Required | The text to look for. |
| `within_text` | Required | The text to search in. |
| `start_num` | Optional | Position to start searching from. Leave it out to start at 1. |

## Examples

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

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

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Email | Order code | Note | Result |
| 2 | maya.chen@acme.com | NY-2026-0142 | Ships Monday | 10 |
| 3 | raj@globex.io | CA-2026-0187 | ships Tuesday | 8 |
| 4 | lee.wong@initech.net | TX-2025-0033 | Backorder | lee |

## Common mistakes

| What you see | Why, 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 work | FIND treats * and ? as literal characters. Use SEARCH when you need wildcards. |
| Off by one when cutting | FIND 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.

## Related functions

- [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.
- [MID](https://spreadsheetpractice.com/functions/mid): MID returns characters from the middle of a text string, starting at a position you choose.
- [LEFT](https://spreadsheetpractice.com/functions/left): LEFT returns a set number of characters from the start of a text string.
- [TEXTBEFORE](https://spreadsheetpractice.com/functions/textbefore): TEXTBEFORE returns everything before a delimiter you name, such as the username before the @ in an email or the first name before a space.
- Comparison: [FIND vs SEARCH](https://spreadsheetpractice.com/functions/compare/find-vs-search)

## 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).

## Practice

A graded FIND exercise ("The classic way") is on [the FIND page](https://spreadsheetpractice.com/functions/find). It is checked instantly, then re-checked on changed data.

Lessons that use FIND:

- [Lesson 21: TEXTBEFORE, TEXTAFTER & FIND](https://spreadsheetpractice.com/learn/textbefore-textafter-find) (Pro)

---

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