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
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelco...
Excel VBA Programming Course: bit.ly/excelvba...
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutoria...
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@...
Quora: bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
/ @excel10tutorial

[@rob8482]

Good job. Perfectly explained!

[@Excel10tutorial]

Thanks. Please subscribe.

[@rob8482]

@@Excel10tutorial I did! Have a good week!

[@Excel10tutorial]

Thanks a million

[@mchiranjibi1331]

Thank you very much dear......

[@Excel10tutorial]

Most welcome 😊 Please subscribe and share.

[@Pipeople2019]

Thank you so much Tutor

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@pragyanbhuyan4532]

thnx

[@Excel10tutorial]

You're welcome

[@AnamozTV]

So fast explained bro, can you get slowly

[@Excel10tutorial]

Yes. It was too fast those days. Check the latest videos. They are better.