The SEARCH function
Returns the number of the character at which a specific character or text string is first found, beginning with start_num(optional).
=Search("margin", "Profit Margin") returns 8
- Find_text - Required. The text you want to find.
- Within_text - Required. The text in which you want to search for find_text.
- Start_num - Optional. The character number in within_text at which you want to start searching.