FIND Function in Excel: Find is nothing but search for something we want, it can be anything like “Things”, “Text”, “Images”, “URL”, etc. In Excel, the search feature is available as a FIND Function. Using this function, we can easily find the data that we need to find from the current worksheet. There are a lot of built-in formulas and functions available in Microsoft Excel.
On that note, we can use this FIND function to get the exact position of the specific character in the Excel worksheet. Here, we will explore the basic syntax and usage of the FIND function in Excel with some examples. Get the official version of MS Excel from the following link:
Description of FIND Function
- The FIND function is one of the built-in functions in Excel.
- You can use this function to get the position (as a number) of one text string on your Excel spreadsheet.
- In other words, it will find out the location of the text and returns the position as a number.
- If the given text is not found on your worksheet, this function returns a #VALUE error.
- This function is case-sensitive and counts the space as one character.
- You need to know that, the FIND Function is similar to the SEARCH function.
- Here, you will see the syntax of the FIND 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.
=FIND(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.
Here we come up with a set of practical examples to make you understand the working nature of the FIND function in Excel.
- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- For example, we have entered the input text string in cell B3, as shown in the below screenshot.
- From that text string, we will find the position of the letter “y” 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.
- Let’s see one more example to make it clear. You can see the input text string the cell B3 and the FIND function counts the space as one character so that it returns the output as 6.
- In the following example, it returns the #VALUE! error. This error indicates that you made a mistake while entering a formula. You have to check it again and then execute the function.
- Here, we have entered a capital letter W in the find_text, so that it returns the #VALUE! error, as FIND Function is case-sensitive.
We hope that the above guide is explained to you clearly regarding the usage of the FIND Function in Excel, with some practical examples. Refer to the given screenshots to understand it quickly. If you have any queries regarding this guide, please leave them in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
The following video will show you how to use the FIND Function on your Excel worksheet with examples. Refer to the below.
- 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?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.