How to Use FIND Function in Excel

In this Excel Function Explained video series, I will explain, how to use FIND function in excel. Excel FIND function is used to find a specific text within a text string and return the starting point in excel. By starting point, I mean, find will give you a location from where your selected text starts. Location means the character number. It doesn’t matter if your data range is formatted as text or number. You’ll be able to use FIND to locate the specified strings that has been filtered based on your provided text.

Let’s learn how to use FIND formula in excel.
The Function looks like this =Find (Find_Text, Within_Text, Starting_Num)

The Find function has Three arguments or parameters.
1. Find_Text: This is the text you need to locate or find.
2. Within_Text: In this parameter, we need to select the cell from which we need to locate the text specified in the first criteria.
3. Starting_Num: This is where you specify the starting point as character number from where your find function will start finding.

Remember “find function” is case sensitive and if you are looking for something that is not case sensitive then you should look into “search function”

This is how we use FIND in excel. Remember, using FIND function in excel you actually tell excel formula to Find a certain text inside a data range you specify.

#Excel #Function #FIND

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[AnamozTV]

So fast explained bro, can you get slowly