Home > Formulas > FIND Function Excel FIND FunctionThese 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 noncasesensitive searches, use the SEARCH function. Note: To look for values on the worksheet, see the Find and Replace page Author: Debra Dalgleish 
Video: FIND FunctionThe Excel FIND function looks for a casesensitive 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 FINDThe FIND function looks for a casesensitive text string, within another text string, and it can:

Ex 3: Find Street Name in AddressIn 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 FileTo 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. Excel TopicsData Val  Pivot  Formulas  Macros  Format  Charts  Filters 
Last updated: August 16, 2022 3:23 PM