I have a list of internet search keywords and I want to filter out ones that have state or city in the keyword string. Is there any way to write a formula that references a list of states/cites and if any of state/city keywords appear in a keyword to have the referenced keyword appear in a cell?
Below example does not show a reference list of state/cities:
<colgroup><col><col></colgroup><tbody>
</tbody>
Below example does not show a reference list of state/cities:
Keyword String | Formula |
1031 exchange properties available in texas | texas |
1031 exchange facilitator washington state | washinton |
1031 exchange california primary residence | california |
1031 exchange rules california real estate | california |
1031 exchange rules real estate california | california |
<colgroup><col><col></colgroup><tbody>
</tbody>