How to Use SEARCH Function in Excel

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

Let’s learn how to use SEARCH formula in excel.

The Function looks like this =Search (Find_Text, Within_Text, Starting_Num)

The Search function has Three arguments or parameters.

1. Search_Text: This is the text you need to locate or Search. This is a mandatory parameter.

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. This is also a mandatory parameter.

3. Starting_Num: This is where you specify the starting point as character number from where your Search function will start Searching. This is NOT a mandatory parameter. If you omit this argument excel will consider this as one and start searching from the first character. If you select it 10 (You’ll always have to write numeric value here), excel will start searching from the 10th character. This is how it works.

Remember “Search function” is NOT case sensitive and if you are looking for something that is case sensitive then you should look into “Find function”: youtu.be/EHosu-m63u0

This is how we use SEARCH in excel. Remember, using SEARCH function in excel you actually tell excel formula to Search a certain text inside a data range you specify.
#Excel #Function #Search

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
patreon.com/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/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse

Social media:
Facebook: facebook.com/excel10tutorial
Twitter: twitter.com/excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: excel10tutorial.tumblr.com
Instagram: instagram.com/excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
youtube.com/@Excel10tutorial/join