How to use AdWords broad match modifier in Excel

by Maria on July 15, 2010

excel name errorWe’ve all been there, with MS Excel on the screen and no idea how to use it for a new feature on Google.

Spare yourself the frustration and the #NAME? error message when you include the plus symbol (+) to indicate a modified broad match keyword.

Here’s how to use AdWords broad match modifier function in:

Excel 2000, 2002, 2003 or 2008 –

  1. On the menu bar, click Edit, then click Replace
  2. In the Find what: field type =+ (equal sign followed by the plus sign)
  3. In the Replace with: field type + (plus sign)
  4. Click Replace All

Excel 2007 or 2010 –

  1. On the Home tab, in the Editing group, click Find & Select
  2. In the Find what: field type =+ (equal sign followed by the plus sign)
  3. In the Replace with: field type + (plus sign)
  4. Click Replace All

In exported keyword lists, you should now see your modified broad match keywords appear. You can prevent this from happening in new rows and spreadsheets by formatting the column containing keywords as text.

In Microsoft Windows Excel 2000, 2002, 2003 or 2008:

  1. Select the column containing keywords
  2. On the menu bar, click Format, then Cells
  3. Click Text from the list of options, then OK

In Microsoft Windows Excel 2007 or 2010:

  1. Select the column containing keywords
  2. On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click Text. If you don’t see the Text option, scroll to the end of the list

{ 3 comments… read them below or add one }


Fatal error: Cannot assign by reference to overloaded object in /misc/22/000/212/306/7/user/web/semwisdom.com/blog/wp-content/themes/thesis_15/lib/functions/comments.php on line 312