Summary

The Excel FIND function returns the position of one text string inside another. For example, =FIND("-", "EC-101") returns 3 because the hyphen is the third character.

FIND is mainly used to locate a delimiter such as a hyphen, slash, space, or colon, then pass that position into another text function. That makes it useful for splitting codes, filenames, email addresses, and other structured text values.

FIND is case-sensitive and does not support wildcards. If you need a case-insensitive search, or if you want wildcard matching, use SEARCH instead.

Syntax

=FIND(find_text, within_text, [start_num])

Use find_text for what you want to locate, within_text for the text to search, and start_num if the search should begin later in the string. If you omit start_num, Excel starts at the first character.

Arguments

• find_text - [Required] The character or text you want to locate. The match must use the same letter case.
• within_text - [Required] The text string or cell reference that contains the search area.
• start_num - [Optional] The position where the search should begin. Use it when the same character appears more than once.

FIND vs Other Functions

FIND and SEARCH are similar, but the matching rules are different. Use FIND when uppercase and lowercase must stay different. Use SEARCH when the match should ignore case or allow wildcards.

If FIND cannot locate the requested text, it returns #VALUE!. Wrap it in ISNUMBER if you only need TRUE or FALSE, or in IFERROR if you want a fallback result such as "not found".

Using FIND

FIND is usually part of a larger formula. In many worksheets, its job is to locate a separator so another function can extract the part before or after it. A standard example is =LEFT(A1,FIND("-",A1)-1), which returns the text before the first hyphen.

The start_num argument matters when the same character appears more than once. It lets you skip the first match and continue searching later in the text, which is useful when you work with repeated delimiters or structured codes.

• Use FIND with LEFT, MID, or RIGHT when you need to split text around a known delimiter.
• Use ISNUMBER(FIND(...)) when you only need to test whether a character or word exists.
• Use start_num when the first occurrence is not the one you want.

Example 1 - Finding Where a Hyphen Is

This is the direct use of FIND. The result is the position of the first hyphen, which you can then reuse in formulas that split the code into separate parts. In a longer value such as "PRO-2025-A", FIND still returns the first hyphen unless you set a later starting position.

=FIND("-", "EC-101")     // Returns 3
=FIND("-", "PRO-2025-A") // Returns 4 (first hyphen only)

Example 2 - Starting the Search from a Specific Position

The third argument changes where Excel starts looking. Here, the search begins at character 2, so the first "e" is skipped and FIND returns the next one instead. This pattern is useful when you need the second or third occurrence of the same character.

=FIND("e", "excel-clash", 2)
// Starts searching from position 2
// Returns 4

Example 3 - Safely Checking if a Character Exists

On its own, FIND returns either a position number or an error. Wrapping it in ISNUMBER turns that into a clean TRUE/FALSE test. This is useful in helper columns, validation rules, and conditional logic.

=ISNUMBER(FIND("X", A4))
// TRUE if "X" is found in A4, FALSE if not found

Example 4 - Extracting Text Before a Delimiter

This is one of the most common FIND patterns. FIND returns the location of the delimiter, then subtracting 1 gives the number of characters before it. That result can be used directly as a length or passed into LEFT to return the prefix.

=FIND("-", A2)-1
// "EC-101" -> 3-1 = 2

=LEFT(A2, FIND("-",A2)-1)
// Extracts "EC" from "EC-101"

FIND counts every character, including spaces. If the text contains leading spaces or repeated spaces, the returned position may be different from what you expect by eye. Cleaning the text with TRIM first can make the result more consistent.

• FIND is case-sensitive.
• If the text is missing, FIND returns #VALUE!.
• Its result is often most useful when another text function uses that position.

Conclusion Recap

• Summary: FIND returns the position of one text string inside another.
• Syntax: =FIND(find_text, within_text, [start_num]).
• Key point: FIND is case-sensitive and does not support wildcards.
• Best use: Locating a delimiter so another formula can split the text.
• Safety tip: Use ISNUMBER or IFERROR when the match may be missing.