Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
FIND
FIND locates the position of a substring within a text string with case sensitivity, returning an error if the substring is not found. Use it to extract substrings with MID or LEFT/RIGHT, or wrap it in ISNUMBER to test whether a specific case-sensitive string exists within a cell.
Excel
=FIND("@",A2)Google Sheets
=FIND("@",A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| alice@example.com |
| bob@sample.org |
| carol@test.net |
| dave@domain.io |
=FIND("@",A2)→6
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Specify the find_text string (the substring to locate) as your first argument.
- 2Reference the within_text cell where you are searching.
- 3Optionally provide a start_num to begin searching from a position other than 1; omit it to search from the beginning.
Need a version for your data?
Try: “Find the position of the @ symbol in an email address to extract the domain”