In this article you will teach yourself how to search for string in column. You may need this trick when you want to check if the cell contains string you need.
In this example you want to check if the cell contains either "text" or "string".
In the data table below you see how data looks like.
To check if "text" or "string" exist just use this formula:
This formula will display TRUE or FALSE in B column. You can use conditional formatting if you want.
Hope this article helped you.