**What is the Excel FIND Function?**

The excel FIND function is looking for a text in another text. The FIND function has NO OPTION for wild card usage and does a case sensitive search.

**FIND Syntax**

FIND(find_text,within_text,[start_num])

find_text, required, text that you want to find.

within_text, required, text in which you want to find the find_text.

start_num, optional, starting position to find the find_text, the default is 1.

**How to Use FIND Function in Excel**

The following are examples of the FIND function usage and the results.

**FIND Function #1**

=FIND(A2,B2)

You can ignore the start_num argument, by default it will be 1. The result is 6, the position of “soft” text in the “Microsoft Excel” text.

**FIND Function #2**

=FIND(A3,B3,C3)

Why is the result not the same as FIND Function #1? Isn’t the “SOFT” text in the “Microsoft Excel” text?

The FIND function looking for in case sensitive way, in the “Microsoft Excel” text there is a “soft” text instead of a “SOFT” text.

To do a case-insensitive search, use the SEARCH function.

- How to Use the SEARCH Function in Excel

**FIND Function #3**

=FIND(A4,B4,C4)

The result is #VALUE! error, because excel FIND function has no option for the wildcard. To search using wildcard option use the excel SEARCH function.

**FIND Function #4**

=FIND(A5,B5,C5)

Why is the result 14? Isn’t there “E” letter at position 11?

The FIND function searches in a case sensitive manner, so the “E” and “e” letter are two different things.

**FIND Function #5**

=FIND(A6,B6,C6)

The FIND function returns a #VALUE! error if the start_num argument contains a zero or a negative number.

**FIND Function #6**

=FIND(A7,B7,C7)

The result is #VALUE! error. No number greater than the length of the text. Use excel LEN function to determine how long is the text,