Excel: How to add keywords with quotes?

Copy and paste with phrase matching doesn't work

[progex]

For some reason, copying and pasting a list of (partial match) keywords in Column A doesn't work. It strips the quotes out, leaving broad matching keywords.

Being new to Excel, perhaps I'm not doing it correctly. Is there a certain way to paste keywords in quotes?

[progex]

Never mind, I found out a work-around.

Apparently, you have to copy the list of partial match keywords from a MICROSOFT application like Word (wordpad and notepad do not work), then paste it into Excel.

[eWhisper]

If copying from another application, this is how you can preserve the quotes:

1. After pasting, a little clipboard will appear at the bottom of the paste. Click on it and select "Use Text Import Wizard"

2. After fixing the first screen you'll see, hit next. At this point you'll see a " with "Text Qualifier" next to it. Change the Text qualifier to {none}.

Then just hit finished. All your quotes will be preserved.

[progex]

Thanks eWhisper, works like a charm.

[kmander]

The tool in my profile can you help you out progex - it wraps your keyword list with whatever targetting options you chose.

[mquarles]

Although it is not exactly the answer to the issue (which has been provided above), I think that it might help if you knew an easy way to add quotes and brackets back in with Excel.

1) put your keyword list in Column B
2) put the " or [ in Column A
3) put the " or ] in Column C
4) copy Column A and Column C all the way down
5) cut and paste Columns A through C into AdWords

The Google system will automatically close up the extra spaces and will consider Column A + Column B + Column C as one term.

If that isn't clear, let me know and I can provide an example.

MQ