Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
Description: In this video, we will learn another function which is called the SEARCH Function. This function is very similar to the FIND function as we have covered in a previous video chapter. The only difference is that the SEARCH function is case insensitive and you can use wildcard operators as compared to FIND. In this tutorial, I will be demonstrating how to search for text using different methods such as Searches For Text Like A Boss! To understand any function better we need to understand its arguments as follows; SEARCH(find_text,within_text,start_num) find_text - This is a required parameter which should be pointing to the cell you want to find text in. within_text - This is also a required parameter which should be pointing to the cell containing the actual text you are searching for. start_num- This is an optional parameter, if your search term contains spaces so it will count starting from this number instead of the default which starts at row one or column A just like how the FIND function works. Therefore, if you watch the video above thats how SEARCH function works and if you get along well you got to know how is it different from FIND function. Table of Content; 00:00 Introduction 00:19 SEARCH Function in Excel 02:06 SEARCH vs FIND Function 05:30 Conclusion We hope you’ve found this video helpful and can use these techniques in your own work. If there are any questions, please contact us for help!