Learn More:- https://exceltutorial.net

Welcome to another episode of text functions and formulas, and in this video, We will learn another function which is called SEARCH Function, Search function is very similar to FIND function as we have covered in previous video chapter, only difference is the SEARCH function is case insensitive and you can use wildcard operators as compared to FIND function. Before jumping onto the video lets talk about SEARCH Functions Syntax and arguments as follows;

=SEARCH(find_text,within_text,start_num)

Find_text - text you want to find. You can use the wildcard characters — question mark (?) and asterisk (*) in find_text.

A question mark matches any single character; an asterisk matches any sequence of characters.

If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Within_text - text in which you want to search for find_text.

Start_num - character number in within_text at which you want to start searching. Use start_num to skip a specified number of characters. For example, suppose you are working with the text string "AYF0093.YoungMensApparel". To find the number of the first "Y" in the descriptive part of the text string, set start_num equal to 8 so that the serial-number portion of the text is not searched. SEARCH begins with character 8, finds find_text at the next character, and returns the number 9. SEARCH always returns the number of characters from the start of within_text, counting the characters you skip if start_num is greater than 1.

**Case insensitive and Usage of Wildcard Operator makes SEARCH Function standout as compare to FIND Function.

All the argument of SEARCH Function are very similar to FIND Function but in the search we have ability to use operators like wildcard, comparison and it also rules out case insensitive part which will help you to rule out the error you gets from FIND function.

Do follow along the table of content below to browse through the different timelines;

Table of Content; 00:00 Introduction 00:19 SEARCH Function in Excel 02:06 SEARCH vs FIND Function 05:30 Conclusion

============================================================

Text Function in excel Playlist

============================================================

Other Playlists:-

Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH

Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1

Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials On ... https://www.youtube.com/watch?v=h7Xs_s8f6sQ