Notifications & Messages

Jared Hamilton
From: Jared Hamilton
Hey - It’s time to join the thousands of other dealer professionals on DrivingSales. Create an account so you can get full access to the articles, discussions and people that are shaping the future of the automotive industry.
×
Cassie Allinger

Cassie Allinger Senior Advertising Performance Strategist

Exclusive Blog Posts

Car Sales Advice For New Salespeople

Car Sales Advice For New Salespeople

When I started selling cars five and a half years ago there were 3 pieces of advice given to me that have helped me succeed in this business. I want to sha…

5 Avoidable Ways that Car Dealerships Can Reduce Staff or Customer Injuries and Liability

5 Avoidable Ways that Car Dealerships Can Reduce Staff or Customer Injuries and Liability

The National Automotive Dealer Association (NADA) data for 2016, revealed that there are 16,708 franchised dealerships in the United States, who sold a rec…

Tips on Finding and Hiring Salesmen Who Have Experience

Tips on Finding and Hiring Salesmen Who Have Experience

Your dealership can't thrive without an experienced sales force. The trickiest part of this equation is finding "rock star" salespeople to he…

New Site Links from Google in Mobile Search

New Site Links from Google in Mobile Search

In thinking of a mobile first world, Google has rolled out new site links to the search results on mobile search.  Historically, Google would award…

What Your Dealership Should Look for in Insurance Coverage

What Your Dealership Should Look for in Insurance Coverage

When a person decides to start a car dealership, insurance needs to be part of their planning. It is a requirement for a dealership to have vehicle insuran…

Quick & Easy Fixes for Dealing With Modified Broad PPC Keywords In Excel

 

Guilty admission: I find cool new tricks very exciting, especially when they provide a solution to an annoying or tedious task. So! You can imagine my excitement (and maybe even a happy dance or two) when I stumbled upon a gem in Twitter promising an easy fix to dealing with modified broad match keywords in Excel.

 

One click later, I found myself knee deep in Mark Jensen’s piece which offers a cool macro and step-by-step directions that will solve all your modified broad match problems. In fact, I was so intrigued that I had read the entire post before realizing that I didn’t need his solution. I found another way to deal with these pesky modified broad match errors years ago, and it’s much much much easier than geeking out with macros. I promise.

 

Problem: The error comes from the fact that Excel places a ‘=’ in front of all ‘+’ because it assumes that ‘+’ indicates a mathematical formula. So all we’re going to do here is a simple find and replace.

Solution: Replace all ‘=’ with a single (‘) apostrophe.

Result: Voila! By removing the ‘=’, the cell contents are transitioned from a formula to a general text format. You’ll also notice that the (‘) which is referred to as a leading apostrophe, will not be shown in the cell, so you’re left with your modified broad match keywords in perfect shape.

That’s it! Easy, painless, and should take you only a matter of seconds when you’re working with keywords in a spreadsheet. With that said, I’m actually a big fan of Mark’s solution, so if you have the time to go through the extra steps of working with his awesome modified broad match macro, check it out. I actually think it could prove to be extremely useful if you have a have a big workbook template that you work with often and don’t want to run F&R each time that you update the data.


Original Post: "An Even Easier Modifed Broad Match Excel Fix" on the Get Found First PPC Blog. 

Jared Hamilton
Cassie - im not sure how I missed this post in early dec, but this is good stuff. A simple solution to a potential big annoyance. Thanks you for sharing.
Cassie Allinger
You're welcome & thanks for the comment Jared! I agree that while it may be a very simple little fix, it's one that causes big headaches for some people. I'm planning to follow up this post with a few more to follow the theme. Stay tuned! :)

 Unlock all of the community & features  Join Now