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

Becoming an ACTIVE leader 101

Becoming an ACTIVE leader 101

Today’s workforce needs immediate feedback, constant counseling and suggestions to maintain motivation and focus on the current goal. The days of bei…

90 Day Boot Camp - Revolutionary, New Sales Training for Automotive Dealers

90 Day Boot Camp - Revolutionary, New Sales Training for Automotive Dealers

Imagine your salespeople starting each day with the most important sales training program available? With The Mar-Kee Group’s new, revolutionary 90 Day B…

Fixed Ops Marketing - Traditional Or Digital?

Fixed Ops Marketing - Traditional Or Digital?

Are mailers just as good or better than digital advertising? That was a question up for discussion recently. The notion that our customers become desensiti…

Challenges of Car Dealerships

Challenges of Car Dealerships

The Car manufacturing industries, just like any other, has got business challenges of its own, which need to be taken care off on a regular basis. Maintain…

How to Destroy Customer Trust in Your Service Department

How to Destroy Customer Trust in Your Service Department

Ask your friends what they think of their dealership’s service department. You’ll get a range of answers, ranging from polite and positive …

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