SEARCH Function in Excel: Microsoft Excel is an excellent utility that allows you to manage and maintain huge data on a spreadsheet. It offers more number of built-in functions and formulas for performing mathematical operations which are difficult to do manually. Whenever you try to search the position of a specific letter in your Excel, then we suggest you use the SEARCH function.
This function will help you to do that. It is one of the built-in functions in Microsoft Excel. By using this function, you can quickly explore the Excel cells and find the specific value (letters or numbers) on your worksheet. Here, we come up with the syntax and usage of the SEARCH function in Excel with some examples. Get the official version of MS Excel from the following link:
Purpose of SEARCH Function
- The SEARCH Function is one of the built-in functions in Excel.
- Anyone who wants to search for the position of a specific character (letter or number) in the Excel spreadsheet, then we recommend using this SEARCH function.
- Excel SEARCH function returns the location or position of the text string that is given in your worksheet.
- This function allows wild cards, and it is not case-sensitive.
- Here, you will see the syntax of the SEARCH function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
=SEARCH(find_text, within_text, [start_num])
- find_text: The text that you want to find.
- within_text: It represents the text where you want to find the position of specific text or string.
- start_num: It is an optional one. This value represents the starting position in the text. By default, this value is 1.
In this portion, we have shown you some examples for your better understanding of the Excel SEARCH function. Let’s see how it works in the spreadsheet.
- First of all, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- For instance, we have entered an input text string in cell B3, as shown in the below screenshot.
- From that text string, we will find the position of the letter “D” by applying the above-mentioned formula.
- Once you have entered the formula, you need to click on the Enter button to get the position of the specific character, as shown below. In this example text string, the SEARCH function counts the space as one character, so that it returns the output as 9.
- Let’s see one more example to make it clear. We have entered the data in a range B3:C5, and we will apply the Search function to find the positions of the specified alphabets and numbers.
- You can refer to the below screenshot, where we have clearly shown the input data and its output values.
We hope that this guide explained the usage of the SEARCH Function in Excel with some practical examples. The provided screenshots let you understand the working nature of this function in Excel.
If you face any struggles while executing this SEARCH function on your spreadsheet, kindly let us know in the comment section. We are always ready to help you. To learn more about Excel functions, then visit our webpage Aawexcel.com.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!