How to use SEARCH Function in Excel | Excel Tips

How to use SEARCH Function in Excel | Excel Tips

The SEARCH and SEARCHB functions in Excel locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. For example, to find the position of the letter "n" in the word "printer", you can use the following function:

Syntax: SEARCH(find_text,within_text,[start_num])