keyword converter from broad to phrase/exact

[mrjibbles]

Hi all

Ive got around 10k in keywords in broad terms

Does anyone know of a way or piece of software which will take them and add
the " " and [ ] to convert them to phrase and exact keywords?

If not , thats alot of editing heh and rsi

many Thanks

Rob

[Aled]

My Solution:

1.Open Excel
2.Copy + Paste keyword list in to column B
3.Add " to column A and C
4.Copy Columns A B and C
5.Open Notepad and paste
6.Select all and Copy
7.Open Word and Paste
8.ctrl+f and select Replace
9.highlight the amount of space between the first letter and " copy it.
10. Paste the space in to Find What: text bar
11.leave Replace with: blank
12.Hit Replace All

I've just tested that out and it seems to work. for [ ] just follow the same steps.

Hope it works for you

[Shane]

excel is pretty fast, and Aled's way is one way.. or you could use the concatenate fucntion (click the "fx" just above column b/c or use "insert" then click "Function" and find concatenate, it might sound a bit complicated but try it, you'll find it's pretty fast once you get used to it and you can save it as a blank sheet for next time and it takes even less time then

for phrase match :
paste keywords in column A
type " in column B row 1
type or use fx button =CONCATENATE(B1,A1,B1) in column C row 1
highlight and then double click the cell borders of B and C and it will do all 10k in one go

for exact match on same sheet :
paste keywords in column E
type [ in column F row 1
type ] in column G row 1
type or use fx button =CONCATENATE(B1,A1,C1) in column H row 1
highlight and then double click the cell borders of F,G and H and it will do all 10k in one go

simply paste your keywords in A and F and then highlight the relevant cells next to A and double click the borders of B and C to make the formula work all the way down as far as the last cell in the column A, then repeat for the exact match keywords

one thing to note !.. when copying and pasting keywords in excel with " and [] .. you'll need to use PASTE SPECIAL then select VALUES radio box option it's on the right click dialogue menu.... DO NOT just paste or Control+V there or it wont work.. . if you use normal paste.. the " and [] will not be pasted... simply highlight the cells you want to copy as you normally would and copy and then click the cell you wish to paste the matched keywords in and then right click and select "PASTE.. SPECIAL" and select the VALUES radio box..

excel sheet attached as a template... hope that saves you some blisters,

[mrjibbles]

WOW!! thankyou very VERY much

I will tackle that tommorrow when my brain is awake

very much appreciated

Rob

[Azam.net]

CONCATENATE? Geez Shane... I give up on competing for title of Geek of the Year 2007. You've already won hands down!

Thanks very much to both Shane and Aled

[beejeebers]

http://www.aff-tools.com/BroadPhraseExact.php

[hpops]

Without Concatenate I would of gone mad about 2 years ago.

[adrian]

I'm one of the latest members of the Concatenate fanclub .

It has saved me a hell of a lot of work and time. Definitely worth a look.

Adrian

[BFG 9000]

As an alternative to concatenate you could have used =B1&A1&B1 instead of =CONCATENATE(B1,A1,B1) (from the example above)

[Keith]

must admit its a term / function I'd not come across

con·cat·e·nate (kŏn-kăt'n-āt', kən-) pronunciation tr.v., -nat·ed, -nat·ing, -nates. 1. To connect or link in a series or chain. 2. Computer Science. To arrange (strings of characters) into a chained list.

[Paul Wright]

Cconcatenate is deffo a great time saver. Another I find useful, particularly when preparing for yahoo and msn is =PROPER(A1) Where A1 is your keyword. This will capitilise your keywords in that column. So "key word" becomes "Key Word".

p.