Keyword Data Filtering Formula in Excel and Open Office

This searches for a specific word in a sentence and will apply a label in the new cell if the certain word is found (Good for making PPC Adgroups from a huge list of keywords)

Open Office
=IF(ISERROR(FIND("TargetWord";B2));"";"LabelWord")

Excel
=IF(ISERROR(FIND("TargetWord",B2)),"","LabelWord")

Leave a Reply