Welcome to WebmasterWorld Guest from 54.167.82.170

Forum Moderators: buckworks & eWhisper & skibum

Message Too Old, No Replies

Excel: How to add keywords with quotes?

Copy and paste with phrase matching doesn't work

     

progex

3:41 pm on Dec 30, 2004 (gmt 0)

10+ Year Member



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

3:43 pm on Dec 30, 2004 (gmt 0)

10+ Year Member



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

3:51 pm on Dec 30, 2004 (gmt 0)

WebmasterWorld Administrator ewhisper is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

4:01 pm on Dec 30, 2004 (gmt 0)

10+ Year Member



Thanks eWhisper, works like a charm.

kmander

6:37 pm on Dec 30, 2004 (gmt 0)

10+ Year Member



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

mquarles

8:47 pm on Dec 30, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month