Know of a good text replacing tool to target adwords searches?

Have a list of keywords, need to create keyword**0.25**dom ain.com/keyword

[rollinj]

Hello fellow webmasters of the world!

I bring you greetings from cool Canada (we're starting to warm up now!) and a question which I thought best fit into this category.

Does anyone know of a powerful (and preferably free) text replacement tool and/or method (I've been wracking my brain trying to figure out a way to do this with the replace function in notepad) that I could use to change a list of keywords in a .txt file like so:

keyword1
keyword2
keyword3

into a google adwords specific list of keywords such as:

keyword1**0.25**http://www.dom ain.com/search?=keyword1
keyword2**0.25**http://www.dom ain.com/search?=keyword2
keyword3**0.25**http://www.dom ain.com/search?=keyword3

I have a newly crafted website, which I've created with much of the help received from posts read on WebmasterWorld already so thanks in advance!

My only trouble is that I have an enormous list of keywords (and an equally large list of actual content pages which I have created from the list of keywords)

Any and all help would be much appreciated. I can't thank you all enough for the great job you're all doing by contributing to WebmasterWorld. It's nice to see a place where everyone works together in harmony, hopefully someday we can bring this type of atmosphere to every corner of the world.

[decaff]

you will need to get up to speed on regular expressions to implement what you want...check your sticky...(but please don't ask me to give you a tutorial...I don't have the time)...good luck..

[rollinj]

Thanks for the speedy reply!

If there's anyone who does have the time to explain how to change this:

keyword

into this:

keyword**0.25**http://www.doma in.com/search?=keyword

then please post your help below. All I need to do (in my own words) is just copy each line of text, and paste it twice on the same line on either size of what will be the same string (**0.25**http://www.doma in.com/search?=) in the center. Any ideas?

[mike_ppc]

it's very easy if you use a spreadsheet program ... with a couple of columns and some formulas

[rollinj]

Yessir that seems to be my answer. That was exactly what I had in mind I just didn't know how to get it out. Thanks so much ppc, good luck in your ppc ventures!

[Israel]

Give this a shot in Excel, Rollingj

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 **0.25**http://example.com/search?=keyword
Don't forget to precede the first * with a space and replace example.com with your domain!

3) In Cell C1, use this formula:

=A1&$B$1

For some reason, it's not clear when posted, but after A1 is an ampersand (&)

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".

7) To test that it worked, you may want to go to Format¦Columns¦Auto Fit Selection. When satisfied, lift column C out of your spreadsheet and paste it.

Voila!

Easy to mess up, so if it don't work the first time, give it another shot.

Israel

[biking4jesus]

you can easily do that in excel or any other spreadsheet program. i have it all setup for using adwords editor for bulk keyword uploads.

[belege]

You can use just 3 lines of php code, if you find excel time-consuming.

[Israel]

You can use just 3 lines of php code

Love to see those 3 lines, belege!

Israel