PDA

View Full Version : How to add commas to a keyword list



admin
07-27-2006, 01:58 AM
Do you need to mass add commas to a large word or text list?

If you're working with keyword lists, you may find yourself needing to add a comma to the end of every keyword.

Adding commas to the end of a line or word is easy.

Especially, if you have a spreadsheet program like excel.

Paste your keyword list in Column A
Enter a Comma in Column B
Scroll or copy/paste the comma and fill to the last keyword entry.

In Column C enter the following

=A1&B1

Then Drag-Fill or copy and paste to fill to the last keyword entry.

Copy Column C and paste into a Text Editor like Notepad..

That's it... takes less then 30 seconds.

pennsylvania_p
07-27-2006, 03:33 AM
heehee, cheers Dan. Sure did save me hours of work, I got like 5227 keywords here related to "mortgage", another niche website I'm in the middle of building - by the time I'm finished I'll have 5227 x 9 pages (9 translation languages), wow, 45,000 pages - hope they bring in some hits...lol), this content generator needs keywords separated with a comma on each line, right bugger it was having to sit here for hours on these other sites I made recently.
Glad that problem is over with. :)

Thanks again.