Close the Skill Gap -> Enroll to be a Certified Financial Modeling & Valuation Analyst (FMVA)® Today!

FIND Function

Returns the position of a specified character or sub-string within a supplied text string

What is the FIND Function?

The FIND Function is categorized under TEXT functions. The function will return the position of a specified character or sub-string within a supplied text string.

 

Formula

=FIND(find_text, within_text, [start_num])

 

The FIND function uses the following arguments:

  1. Find_text (required argument) – It is the character or sub-string we wish to find.
  2. Within_text (required argument) – It is the text string that we need to search.
  3. Start_num (optional argument) – It specifies the position in the within_text string, from which the search should begin. If we omit the argument, it will take on the default value of 1, that is, it will begin the search at the start of the within_text string.

 

How to use the FIND Function in Excel?

As a worksheet function, FIND can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider an example:

 

Example 1

Suppose we wish to find certain characters from the data below:

  • Data is not correct
  • Revenue grew by 5%
  • Original Text

 

The results in Excel are shown in the screenshot below:

 

FIND Function

 

Note that in the above spreadsheet:

  1. Due to the case-sensitivity of the FIND function, the uppercase and lowercase find_text values, “T” and “t”, will return different results.
  2. If we kept the [start_num] argument to 4, the search begins at the fourth character of the within_text string.

 

Few things to remember about the FIND Function:

  1. The FIND function will return the location of the first instance of find_text in within_text.
  2. The location is returned as the number of characters from the start of within_text.
  3. Start_num is optional and defaults to 1.
  4. FIND will return a #VALUE error if find_text is not found in within_text.
  5. The function is case-sensitive and does not support wildcards.
  6. We can use the SEARCH function to search without case-sensitivity and/or to use wildcards.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions and enrolling in the CFI Financial Analyst Program you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

  • Excel Functions for Finance
  • Advanced Excel Formulas Course
  • Advanced Excel Formulas You Must Know
  • Excel Shortcuts for PC and Mac

Free Excel Tutorial

To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

 

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!