What it does
FIND returns a position, not text. =FIND("-","KBL-1525") returns 4 because the hyphen is the fourth character. The number is rarely useful on its own; its real job is to tell LEFT, RIGHT and MID where to cut.
FIND is case-sensitive and does not support wildcards: "a" and "A" are different, and * looks for an actual asterisk. If you want to ignore case or use wildcards, use SEARCH. When the text is not found the result is #VALUE!, so "does it contain…?" is asked as =ISNUMBER(FIND(…)).
The third argument starts the search further along the text. To find the second hyphen, add one to the position of the first and search from there: =FIND("-",A2,FIND("-",A2)+1). The result is still counted from the start of the text.
Syntax
=FIND(find_text, within_text, [start_num])=BUL(bul_metin; metin; [başlangıç])Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
find_text | Required | The character or text to look for. The search is case-sensitive, and * and ? are treated as ordinary characters. Empty text returns the start position. |
within_text | Required | The text, or cell, to search in. |
start_num | Optional | The character position where the search starts; 1 if omitted. It cannot be less than 1 or longer than the text. |
Examples
1Get the domain from an email address
Column B finds the position of the @; column C uses MID to take the rest, starting one character after it.
=FIND("@",A2)| A | B | C | |
|---|---|---|---|
| 1 | @ Position | Domain | |
| 2 | sales@brownandsons.co.uk | 6 | brownandsons.co.uk |
| 3 | accounts@northgate.com | 9 | northgate.com |
| 4 | info@harbourtrade.co.uk | 5 | harbourtrade.co.uk |
| 5 | support@starmarket.com | 8 | starmarket.com |
- B2 (filled down to B5)
=FIND("@",A2) - C2 (filled down to C5)
=MID(A2,B2+1,100)
In the first address the @ is character 6, so the domain is brownandsons.co.uk. Because num_chars is 100, the whole domain is returned however long it is.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Find the second hyphen and take the suffix
The middle part of the codes has different lengths. To find the second hyphen, the search starts one character after the first.
=FIND("-",A2,FIND("-",A2)+1)| A | B | C | |
|---|---|---|---|
| 1 | Product Code | 2nd Hyphen | Colour Code |
| 2 | KBL-1525-SY | 9 | SY |
| 3 | PRZ-21-BY | 7 | BY |
| 4 | SGT-0016-C | 9 | C |
| 5 | KNL-120-GR | 8 | GR |
- B2 (filled down to B5)
=FIND("-",A2,FIND("-",A2)+1) - C2 (filled down to C5)
=MID(A2,B2+1,10)
The second hyphen is character 9 in the first code and 7 in the second, yet each row returns only the suffix: SY, BY, C.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
3Does the note mention "VAT"?
ISNUMBER returns TRUE when FIND found a position and FALSE when it returned #VALUE!. FIND looks at case, so only "VAT" in capitals counts.
=ISNUMBER(FIND("VAT",B2))| A | B | C | |
|---|---|---|---|
| 1 | Quote | Note | VAT Note |
| 2 | Q-101 | VAT included | TRUE |
| 3 | Q-102 | vat excluded | FALSE |
| 4 | Q-103 | Freight extra | FALSE |
| 5 | Q-104 | Add VAT at 20% | TRUE |
- C2 (filled down to C5)
=ISNUMBER(FIND("VAT",B2))
In Q-102 the lower-case vat is not found: FALSE. To search regardless of case, use SEARCH instead of FIND.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #VALUE!
Cause: The text was not found. Often the case is different ("vat" against "VAT") or the delimiter is missing in that row. A start_num below 1 or beyond the end of the text gives the same error.
Fix: If case does not matter, use SEARCH; for rows where nothing is found, wrap the formula in IFERROR.
- Position off by one
Cause: The text starts with an invisible space, so every position shifts by one and LEFT or MID cut in the wrong place.
Fix: Search the cleaned text:
=FIND("-",TRIM(A2)).
Good to know
- To check whether a cell contains some text, use
=ISNUMBER(FIND("KBL",A2)); the result is TRUE or FALSE. - Finding the last occurrence is awkward with FIND; in Microsoft 365, use TEXTAFTER for the part after the last delimiter.
In Nexell
Get Nexell to do it from a sentence
Put the domain after the @ in each email address into a new Company Domain column
Convert to tableBring your address list into the tool and type this. Nexell builds the new column with real Excel text formulas and shows it in the preview first; in the downloaded file, the domain changes when the address changes.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between FIND and SEARCH?
Both return a position. FIND is case-sensitive and ignores wildcards; SEARCH ignores case and accepts the ? and * wildcards. Use FIND for exact codes and SEARCH for free-form descriptions.
How do I check if a cell contains specific text?
=ISNUMBER(FIND("VAT",A2)) returns TRUE when the text is there and FALSE when it is not. Turn it into a label with IF: =IF(ISNUMBER(FIND("VAT",A2)),"Yes","No").