Skip to content

How to Use Excel FIND Function?

Listen to this article

FIND Function in Excel: Find is nothing but search for something we want, it can be anything like “Things”, “Text”, “Images”, “URL”, etc. In Excel, the search feature is available as a FIND Function. Using this function, we can easily find the data that we need to find from the current worksheet. There are a lot of built-in formulas and functions available in Microsoft Excel.

On that note, we can use this FIND function to get the exact position of the specific character in the Excel worksheet. Here, we will explore the basic syntax and usage of the FIND function in Excel with some examples. Get the official version of MS Excel from the following link:

Excel FIND FunctionPin
Excel FIND Function

Description of FIND Function

  • The FIND function is one of the built-in functions in Excel.
  • You can use this function to get the position (as a number) of one text string on your Excel spreadsheet.
  • In other words, it will find out the location of the text and returns the position as a number.
  • If the given text is not found on your worksheet, this function returns a #VALUE error.
  • This function is case-sensitive and counts the space as one character.
  • You need to know that, the FIND Function is similar to the SEARCH function.


  • Here, you will see the syntax of the FIND function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.

=FIND(find_text, within_text, [start_num])

Argument Explanation

  • find_text: The text that you want to find.
  • within_text: It represents the text where you want to find the position of specific text or string.
  • start_num: It is an optional one. This value represents the starting position in the text. By default, this value is 1.

Practical Examples

Here we come up with a set of practical examples to make you understand the working nature of the FIND function in Excel.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • For example, we have entered the input text string in cell B3, as shown in the below screenshot.
Enter the formulaPin
Enter the formula
  • From that text string, we will find the position of the letter “y” by applying the above-mentioned formula.
Input ValuePin
Input Value
  • Once you have entered the formula, you need to click on the Enter button to get the position of the specific character.
  • Let’s see one more example to make it clear. You can see the input text string the cell B3 and the FIND function counts the space as one character so that it returns the output as 6.
Use FIND FunctionPin
Use FIND Function
  • In the following example, it returns the #VALUE! error. This error indicates that you made a mistake while entering a formula. You have to check it again and then execute the function.
  • Here, we have entered a capital letter W in the find_text, so that it returns the #VALUE! error, as FIND Function is case-sensitive.
Value Error OccurredPin
Value Error Occurred


We hope that the above guide is explained to you clearly regarding the usage of the FIND Function in Excel, with some practical examples. Refer to the given screenshots to understand it quickly. If you have any queries regarding this guide, please leave them in the below comment section. To learn more about Excel functions, then visit our webpage

Video Tutorial

The following video will show you how to use the FIND Function on your Excel worksheet with examples. Refer to the below.

Read Also:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...