Question

To find the position of a substring in a text string, use the SEARCH function. ... ​

Answer 1

To find the position of a substring in a text string, use the SEARCH function. ...

Add the ISNUMBER function. ...

You can also check if a cell contains specific text, without displaying the substring. ...

To perform a case-sensitive search, replace the SEARCH function with the FIND function