Use

The Search() function returns the starting location of a given text substring inside of a text value.

Search() is not case sensitive. The Find() funtion works similarly but with case sensitivity.

You can also start the search at a specified character by providing a start number. This will skip over the part of the text value before the start number.

Examples

• Search("C", "ABCDEFG")  = 3
• Search("c", "ABCabc")  = 3
• Search("morning", "Good morning! Do you wish me a good morning?")  = 6
• Search("morning", "Good morning! Do you wish me a good morning?", 10)  = 37