FIND Function in Excel




In this tutorial, you will learn about how to use excel FIND function. Excel FIND function will help you to get the position of a character in data or cell content


Why We Need to Learn About Excel FIND Function?


The main usage of this FIND function in excel is to help us giving input to the MID formula if we want to make a character position or the grouping of it as starting position reference of the process in MID.

In data or cell content on the spreadsheet software where there is separation sign for each part in it, sometimes the position of the separation sign is different in each data entry. If we want to use MID to separate characters for our analysis needs, this problem will make it difficult for us to use the usual number input in determining the starting position of the process because the starting position for each data that we want to process is different for each data entry.

To solve the problem, you can use excel FIND function. FIND function in excel can return for you the number that represents the position of a character in data or cell content based on your inputs in its writing. The previous different position problem of separation sign can be solved with the usage of it.


What is FIND Function in Excel?


FIND function in excel is a formula to get the position of a character or its grouping in data or cell content. This formula is usually combined with MID to get the character as we want with the dynamic starting position of MID formula process for each data entry.

But, of course, you need to identify the data or cell content pattern first and know what character becomes the separation sign in it before writing the excel FIND function to help you.

The following will explain a little bit about the inputs in the formula:

=FIND(find_text, within_text, [start_num])


Notes:
  • find_text = part of the data that you want to find the position of
  • within_text = the data
  • start_num = optional. Determines the starting position to find the data part



How to Use Excel FIND Function?


The following will explain how to utilize FIND function in excel. Excel FIND function needs the input of character to be searched, data or cell coordinate where the character will be searched in, and the starting point of where the searching process will begin on the data or cell content (optional)


Using FIND Function in Excel

  1. Type equal sign ( = ) in the cell where you want to put the result in

    FIND Function in Excel - Screenshot of Step 1

  2. Type FIND (can be with large and small letters) and open bracket sign after =

    FIND Function in Excel - Screenshot of Step 2

  3. Type character or group of character which want to be found or cell coordinate where it is in after open bracket sign followed by a comma sign ( , ). If the input in this part is not just number, then it must be inputted between quotation mark ( “ )

    FIND Function in Excel - Screenshot of Step 3

  4. Type data/cell coordinate where the content which you want to search using with this formula is after open bracket sign

    FIND Function in Excel - Screenshot of Step 4

  5. Optional: Type a comma sign ( , ) and then the number which represents the starting position of character search in the data or cell content/cell coordinate where this number is. If there is no input in this part, then the search will be done from the front position

    FIND Function in Excel - Screenshot of Step 5

  6. Type close bracket sign

    FIND Function in Excel - Screenshot of Step 6

  7. Press Enter
  8. The process is done!

    FIND Function in Excel - Screenshot of Step 8



Exercise


After you learn from the tutorial, you can practice your understanding through the exercise below!

Download the file from the following link and answer the questions. Please download the answer file if you have done the exercise and sure about the result!

Link to download exercise file:
Download here

Questions

  1. What is the number position of the fourth “_” sign in the index code?
  2. What is the number position of 4562 sign in the index code?
  3. Try to take 11021990 digits from the index code by using MID formula combined with excel FIND function! (This question might be a little hard to be answered. You must learn about MID formula first in another part of this Compute Expert tutorial blog if you don’t know how to write MID formula needed to answer this question!

Link to download answer file:
Download here


Additional Note


The usage of FIND function in excel mainly is to help you in writing MID formula when you need it in this spreadsheet tool. The tutorial of MID can be learned in another part of this Compute Expert blog!



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert