SEARCH

Explanation

SEARCH function lets us find the position of a text within another text/cell. 

Note that FIND is case-insensitive. You can use it to lookup lowercase/uppercase letters – all combinations will work. In case you are looking for a case-sensitive alternative, use the FIND function instead. 

Syntax

=SEARCH(find_text, within_text, [start_num])

find_text – The text for which we’d like to find the position in the second text.

within_text – In which text we are looking for the “find_text”. Within_text can be either a simple text string or a reference to a cell. 

[start_num] – Optional. In case you want to start the lookup from a specific position in text, you can type the start number here. If not used, the default is starting from the beginning of the text/cell.

Example

Practice SEARCH function