SEARCH Returns the number of the character at which a specific character or text string is first found, reading left to right. Search is case-insensitive and accent sensitive.
SEARCH(find_text, within_text[, [start_num][, NotFoundValue]])
find_text – The text that you want to find.
You can use wildcard characters — the 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 – The text in which you want to search for find_text, or a column containing text.
start_num – (optional) The character position in within_text at which you want to start searching. If omitted, 1.
NotFoundValue – (optional) The value that should be returned when the operation does not find a matching substring, typically 0, -1, or BLANK().
The number of the starting position of the first text string from the first character of the second text string.