Excel formula to search cell for multiple strings

You can use this formula in Excel to search for multiple different strings appearing in a column:

=IF(OR(ISNUMBER(SEARCH({"east","west","north","south"},A1))),A1, "")

So in this example we are searching for four terms in cell A1, and then in column B returning the full entry in the cell if any one of the strings is present. The formula is pulled down with CTRL + D and each time a UK constituency includes east, west, north or south, an entry is pulled into column B.

Thanks to T. Valko for posting this formula here.

https://www.mrexcel.com/forum/excel-questions/601195-check-multiple-text-strings-cell.html