Simple Formula to Change Your Broad Match To Modified Broad Match

Posted by adwordsninja on Sep 2, 2010 in PPC | 0 comments

As experienced PPC Advertisers know, Google recently rolled their modified broad match modifier to all accounts.

Being a “PPC Guru”, I needed to find a way to turn all of my broad match terms into broad match modifier using excel, simple & easy.
The formula is simple:

=concatenate(“+”,substitute(a2,” “,” +”)

Attached is a spreadsheet with the formula sample… Yes, you will still need to reupload to Google Adwords editor or something. BTW, you can do this in adwords itself, using Google’s in-table editing.

Alternatively, you can download Chad Summerhill’s Excel Macro, or use Maria Nichita’s Find Replace Strategies.