Skip to content

Excel function · Text

Excel FIND function

FIND tells you at which character one text starts inside another: the position of the @ in an email address or the hyphen in a code. The result usually feeds LEFT or MID.

In Turkish Excel: BUL

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

English Excel=FIND(find_text, within_text, [start_num])
Turkish Excel=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

ArgumentRequiredDescription
find_textRequiredThe 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_textRequiredThe text, or cell, to search in.
start_numOptionalThe 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.

B2fx=FIND("@",A2)
Get the domain from an email address: example table
ABC
1Email@ PositionDomain
2sales@brownandsons.co.uk6brownandsons.co.uk
3accounts@northgate.com9northgate.com
4info@harbourtrade.co.uk5harbourtrade.co.uk
5support@starmarket.com8starmarket.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.

B2fx=FIND("-",A2,FIND("-",A2)+1)
Find the second hyphen and take the suffix: example table
ABC
1Product Code2nd HyphenColour Code
2KBL-1525-SY9SY
3PRZ-21-BY7BY
4SGT-0016-C9C
5KNL-120-GR8GR
  • 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.

C2fx=ISNUMBER(FIND("VAT",B2))
Does the note mention "VAT"?: example table
ABC
1QuoteNoteVAT Note
2Q-101VAT includedTRUE
3Q-102vat excludedFALSE
4Q-103Freight extraFALSE
5Q-104Add 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

Type this in Nexell

Put the domain after the @ in each email address into a new Company Domain column

Convert to table

Bring 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").

Related functions

All text functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free