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:
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.