TextLevel: IntermediateAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Common errors and fixes
- Related functions
FIND returns where one text starts inside another. It is case-sensitive and does not allow wildcards — use SEARCH for that.
Syntax
=FIND(find_text, within_text, [start_num])
| Argument |
What it means |
start_num |
Where to start looking (1 if omitted). |
Examples
Example 1
=FIND("@", A2)
Position of @ in an email.
Example 2
=FIND(" ", A2, FIND(" ", A2)+1)
Position of the second space.
Common errors and fixes
| You see |
Why, and the fix |
#VALUE! |
Text not found, or different case. Use SEARCH, and wrap with IFERROR. |
SEARCH · MID · LEFT
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong