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

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

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

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 ( “ )

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

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

Type close bracket sign
 Press Enter

The process is done!
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
 What is the number position of the fourth “_” sign in the index code?
 What is the number position of 4562 sign in the index code?
 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!