Search for string in column

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.

Search for string in column data table

To check if "text" or "string" exist just use this formula:

=IF(IFERROR(FIND("text",A2,1),0)+IFERROR(FIND("string",A2,1),0)>0,"TRUE","FALSE")

Search for string in column

This formula will display TRUE or FALSE in B column. You can use conditional formatting if you want.

Hope this article helped you.