Home > Formulas > FIND Function
Excel FIND Function
These Excel FIND function examples show how to look for a text string (case sensitive), within another text string, and return its position, if found. For non-case-sensitive searches, use the SEARCH function.
Note: To look for values on the worksheet, see the Find and Replace page
Author: Debra Dalgleish
Video: FIND Function
The Excel FIND function looks for a case-sensitive text string, within another text string, and returns its position, if found. Watch this short video to see 3 examples of how to use FIND. There are written steps below the video.
Uses for FIND
The FIND function looks for a case-sensitive text string, within another text string, and it can:
The FIND function has the following syntax for its arguments:
The FIND function has a few traps:
Example 1: Find Text in String
To find specific text in a text string, you can use the FIND function. It is case sensitive, so in the screen shot below, the first two “i” characters are ignored, because they are lower case.
Tip: To handle errors, if the text is not found, you can wrap the FIND function with the IFERROR function.
Ex 2: Find Exact Values from List
Because FIND is case sensitive, you can use it to find exact strings in another string.
In this example, there are valid codes listed in column E.
With the following FIND formula, you can identify any ID numbers in column B that contain one of the valid code strings.
Complete the Formula
Ex 3: Find Street Name in Address
In the next example, most of the addresses in column B start with a street number.
With the formula in column C, we check for a number in the first character.
If the first character is a number
Here is the formula in cell C2:
Get the Sample File
To see the formulas used in these examples, download the FIND function sample workbook. The file is zipped, and is in Excel xlsx format, with no macros.
Data Val | Pivot | Formulas | Macros | Format | Charts | Filters
Last updated: August 16, 2022 3:23 PM