How to "Append a single line/word to all lines in text file"?

[deboogeek]

I have a file containing a word-list / site-list.

I want to append another site/url to each of these words which are in thousands.

How can I do that? Is there any software I can use to do this for me?

Doing it manually would be a great pain - Ctrl-V, then left-cursor, then cursor-down, then again Ctrl-V.

Is there any text editor that has this capability or is there a way this can be done in notepad/wordpad/word or any available windows software? Linux software is okay too as long as it can do this kind of job.

Regards,
Deboo

[Stevoni]

Are these "columns" separated by anything, like a comma? If so, you can open it up in Excel and use excel to paste the new word into all the rows.

You may need to changed the file extension (the .txt) to ".csv" in order to Excel to handle it correctly.

[deboogeek]

Are these "columns" separated by anything, like a comma? If so, you can open it up in Excel and use excel to paste the new word into all the rows.

You may need to changed the file extension (the .txt) to ".csv" in order to Excel to handle it correctly.

Okay I pasted the list in excel. Now how do I append the site / new word on to all the rows in one go?

[Stevoni]

Okay I pasted the list in excel. Now how do I append the site / new word on to all the rows in one go?

Well are there two columns or only one?

If there are two, then yeah, you can copy the word all the way down.

[deboogeek]

Well are there two columns or only one?

If there are two, then yeah, you can copy the word all the way down.

All single column, one word per line.

It's like this:

google.nl
hyves.nl
google.com
wordpress.com

And this is what I want the above to be like:

http://www.quantcast.com/google.nl
http://www.quantcast.com/hyves.nl
http://www.quantcast.com/google.com
http://www.quantcast.com/wordpress.com

Any ways this can be done? Excel or any other software?

Regards,
Deboo

[Stevoni]

You're going to be using three columns, the first column will have your first words (google.com), the second column will have "http://www.quantcast.com/" and in the third column, 1st row you'll put exactly "=CONCATENATE(B1,A1)". This will have the third column, 1st row, show "http://www.quantcast.com/google.com".

Now the hard work is complete, you'll go to the bottom right corner of the third column, 1st row until it becomes a cross. At that point, drag it down to the the last row of your list and your column should look correct.
or
You can copy the third columns 1st row cell and select the cells to replace (the entire third column down to the last row of your original list) and paste the contents.

Hope this helps!

[deboogeek]

Hope this helps!

Of course it helped a great deal! Thank you so very much. It saved me lots of time.

Regards,
Deboo

[deboogeek]

You're going to be using three columns, the first column will have your first words (google.com), the second column will have "http://www.quantcast.com/" and in the third column, 1st row you'll put exactly "=CONCATENATE(B1,A1)". This will have the third column, 1st row, show "http://www.quantcast.com/google.com".

Hope this helps!

I see I have a small problem here.

I did as you suggested above. And once I got the results I wanted,

I copied the whole 3rd colum and pasted the contents into notepad.

Then deleted the 2nd and 3rd columns completely from the excel sheet, I cut-pasted the text from notepad back into excel.

I got all the text as I wanted but the links aren't clickable.

I also see that if I put a single space in front of each of those links, they become blue and clickable.

How do i insert a single space in each cell of the whole column?

(Yes, I wanted these within excel and to be clickable.)

Regards,
Deboo

[Stevoni]

You don't have to put the space in front of it, just press F2 to enter the cell and press enter to force Excel to validate the information again.

To fix your larger issue of not wanting to press F2 a ton, after the first cell has been converted to a URL link, use the select the cell next to it and using the arrow keys select the cell you previously correct to become a URL. Click the format painter and select the column heading to change the format of the column to that of the selected cell.

[deboogeek]

You don't have to put the space in front of it, just press F2 to enter the cell and press enter to force Excel to validate the information again.

To fix your larger issue of not wanting to press F2 a ton, after the first cell has been converted to a URL link, use the select the cell next to it and using the arrow keys select the cell you previously correct to become a URL. Click the format painter and select the column heading to change the format of the column to that of the selected cell.

Thanks again, it worked like a charm!

However, the links are blue but when I put the mouse cursor over them, the white cross does not change to a hand, except for on the first one.

Does it mean I need to do this manually for each of them?

Regards,
Deboo

[Stevoni]

Does it mean I need to do this manually for each of them?

Regards,
Deboo

I guess it does. Just get into a routine of pressing F2 and the enter key and you'll be alright. :cool:

[deboogeek]

I guess it does. Just get into a routine of pressing F2 and the enter key and you'll be alright. :cool:

Not a big problem, and it still saves me time rather than having to copy paste the urls into the browser address bar. And doing it in batches of 100-200 at a time is good enough for me.

Only thing I'm a little worried about is 10,000 times pressing the F2 and Enter key ... my keyboard's keys' life will be affected ...

[Shtanto]

Thanks again, it worked like a charm!

However, the links are blue but when I put the mouse cursor over them, the white cross does not change to a hand, except for on the first one.

Does it mean I need to do this manually for each of them?

Regards,
Deboo

I'd do this a little bit differently.

Where I work, we have to add numbers in front of letters fairly often.

As an example, we might have a list of animals in column A and a list of colours in column B

Dog Black
Cat Orange
Mouse White

Now if I want 3 words in 3 columns, I'd say =B2&" "&A2 in the C column
This would put the words Black Dog in C1. I can drag this down and excel will copy whatever is in B with whatever is in A and join them together in C. Just remember to paste values if you are pasting. I prefer using this method because I can add words between the "" marks like =B2&" flying "&A2. It's a bit easier than trying to spell concatenate all the time!