IntermediateText
Syntax
=FIND(find_text, within_text, [start_num])| Argument | What it means |
|---|---|
find_text | The text to look for. |
within_text | The text to search in. |
start_num | Optional. Where to start. 1 is the first character. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Examples that need no data
=FIND("@","amira@example.com")The @ is the 6th character
Contact list pasted from an email (fictional)
| Row | A | B |
|---|---|---|
| 1 | Raw name | |
| 2 | amira HASSAN | Amira.Hassan@Example.com |
| 3 | ben CARTER | ben.carter@example.com |
| 4 | CHEN wei | CHEN.WEI@EXAMPLE.COM |
| 5 | dina ali | dina.ali@example.com |
=FIND(".",B2)Position of the first dot
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use FIND at work
- Administration
Split an email into name and domain.
Data: Contact list pasted from an email (fictional)=MID(B2,FIND("@",B2)+1,50) - HR
Find the space between first and last name.
Data: Team list (fictional)=FIND(" ",A2)
Common mistakes and tips
- If the text is not found you get #VALUE!. Use IFERROR or SEARCH if you do not need case matching.
Works in
All versions of Excel, and Google Sheets.
Related formulas
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.