Web Marketing Experts Blog
Posted on 14th Nov 2016 by David Ogletree
Sometime I get a list of keywords that I want to convert to phrase match. Most often I do this when I'm creating negative keyword lists but this works for normal phrase match as well. Put your keywords in a single column in Excel and then past this formula in the first cell of the next column and hit return. In order to use this on the entire column just double click on the bottom right of the cell you just pasted the formula into. This will copy the formula to ever cell in that column.
Just copy the entire column over to Google AdWords or Google AdWords Editor.
=IF(COUNTIF(A1,"* *"),"""" & A1 & """", A1)
There’s no issue or question too large or too small – contact David with your individual needs today! Drop him a line or ask your question here and he’ll get back to you within 24 hours or less.