Keyword Pharse Question

[surf4soul]

I have over 7,000 keywords that I want to put in "quotes" Is there a way to do that all at once. Not manualy?

Thanks

Keivn

[2oddSox]

mquarles suggested a solution to that in this thread [webmasterworld.com] (message #6). Perhaps it can do what you want?

[patient2all]

That's a fine method which will certainly work. Can I show off how I took an Excel class and learned this neat trick which is faster, I think?

Thanks!

1) Copy all your keywords into Column A. Say "Yes" to the message about the data in the clipboard not being the same size.....

2) In Cell B1 put a "

3) In Cell C1, use this formula:

=$B$1&A1&$B$1

4) Right Click and Copy Cell C1

5) Drag Column C as far down as the last keyword goes

6) Right Click and then select "Paste Special", then "Formulas Only".

Voila!

Now if you wanted to do exact matches, the process would be only slightly different.

1) Copy all your keywords into Column A. Say "Yes" to the message about the data in the clipboard not being the same size.....

2) In Cell B1 put a [

3) In Cell C1 put a ]

4) In Cell D1, use this formula:

=$B$1&A1&$C$1

5) Right Click and Copy Cell D1

6) Drag Column D as far down as the last keyword goes

7) Right Click and then select "Paste Special", then "Formulas Only".

----

Isn't that neat?

patient2all

[PatrickDeese]

This formula may work better, so when you copy and paste the keywords you don't have any errant " or [ to deal with:

(col a) (keyword)
(col b) =""""&A1&""""
(col c) ="["&A1&"]"

Then just click on the col B tab so the entire column highlights and press ctrl D - which will copy the formula through the whole column, then repeat the same steps for col C.

You can paste KW lists into Col A, and you will have keyword, "keyword" and [keyword] automatically.

The only catch is that you have to separate the three terms manually because they get posted in a row.

This formula was posted in the forum a couple of months ago, but I can't find the original thread.

[eWhisper]

If you're really lazy, you can put them all into your AdWords account, then use the 'change keyword matching options' Google tool to make all broad match keywords change to phrase match.

[patient2all]

you don't have any errant " or [ to deal with:

Patrick,

I beg to differ, by using the CTRL<D> to copy the formula column-wide, you end up with endless errant delimeters beneath the last keywords in B & C and it required a lot more mouse dexterity to gather the real results. That's why I suggested dragging the absolute reference down to the last of your keywords; you end up with no extra brackets or quotes that way, IMHO.

You know something guys, these back and forth debates about the relative merits of different approaches to problems is the only thing I miss about the 9-5 world of cubicle hell!

This formula was posted in the forum a couple of months ago, but I can't find the original thread.

I too searched for the original thread your solution appeared in and couldn't find it either. I remembered it mentioned the CONCATENATE function (of which '&' is certainly a preferable shortcut for).

CONCATENATE EXCEL and numerous variants turned up no results.

The search function on this board is generally useless. Is there any way you can search within a single forum at least?

-----

eWhisper, Although I am very lazy, I'll start letting AdWords change my matching options automatically right after I start using AdWords to determine my budgets and keyword bids :)

patient2all

[PatrickDeese]

I usually copy from the bottom up with with arrow shift commands, easy peasy... but hey - whatever works.

Everyone uses Google site search to search this site.

[eWhisper]

Is this the post you're looking for?
[webmasterworld.com...]

FYI - this is the way to search webmasterworld:
[webmasterworld.com...]