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”: • How to Use FIND Function in Excel
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
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Watch video How to Use SEARCH Function in Excel online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 07 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 49,778 once and liked it 167 people.