Convert Row Into Comma Separated List?

Krazy Kitty

Krazy Kitty

Regular Member
Joined
Feb 11, 2008
Messages
383
Reaction score
158
If I have the following list of keywords:

cat foot
good cat foot
tasty cat foot

How can I easily convert it into a comma separated text file like this:

cat foot, good cat foot, tasty cat foot

Any bright ideas?
 
Advertise on BHW
I'm using open office. I can't get it to work like that.
 
Choronzon said:
PM it to me and I'll convert it and send it back
Click to expand...

I appreciate the offer, Choronzon. That's very kind of you. But this is something I will need to do a lot. I do it every day by hand. I was just wondering if there was an easier way to save me some time.
 
You can do it in ooCalc - here's a tutorial

http://sheepdogguides.com/fdb/opof8csv.htm
 
Great question and I'm glad I have the solution (and then some).

1. Download ASAP Utilities (is a free Excel add-in that you will love and be willing to give money too... trust me)
2. Once you have it installed, open Excel. You will notice the AddIn 'ASAP Utilities'. If you do not see it, open it via the Start > Programs...
3. With your range selected, and with ASAP open, click on Fill > Insert After Current Value, and then in the box, type the comma.

This approach will add a comma at the end of every row/final word.

There may be an easier way to do this but once you open ASAP Utilities and see what all it can do, you will be hooked. I use it many times a day every day and best of all, it is FREE.

---http://www.asap-utilities.com/

I hope that helps you and others.
 
copy all keywords in Micr0s0ft w0rd.
Select Edit>Replace
It opend Find and Replace Dialog box
give find what as : ^p (press shift key+6 for this ^ and use small p)
give Replace with as : , (Comma)
click on Replace all

Thats it
 
Krazy Kitty said:
If I have the following list of keywords:

cat foot
good cat foot
tasty cat foot

How can I easily convert it into a comma separated text file like this:

cat foot, good cat foot, tasty cat foot

Any bright ideas?
Click to expand...

the most easiest way is to use this free tool:

Code: 
http://www.jumbokeyword.com

can do 70+ actions with your keywords
 
yesrams said:
copy all keywords in Micr0s0ft w0rd.
Select Edit>Replace
It opend Find and Replace Dialog box
give find what as : ^p (press shift key+6 for this ^ and use small p)
give Replace with as : , (Comma)
click on Replace all

Thats it
Click to expand...


I was looking for something like that too.

Your method is working very well and it's simple.
Thanks
 
another method which I use is to get a program that has a macro feature (i use ultraedit)

then go to the menu -> record macro

and then you can use a macro like 'press the end button' -> 'press the , button' -> 'press space (optional)' -> 'press delete (so the second line will be on the first line too)'

then save this macro and run it xx times or just select until end of file (sometimes that feature is unreliable so i prefer to run it xx times) (Macro Menu -> Play Any/Multiple Times)

this method is great for converting any text that has a format to another format
 
Download openoffice it's free and has almost all the features of microsoft office then open scalc it's like excel insert the values into the cells and save as a csv you will be asked if you want to save with the values like " and , say yes and that's it you got a csv file.
 
yesrams said:
copy all keywords in Micr0s0ft w0rd.
Select Edit>Replace
It opend Find and Replace Dialog box
give find what as : ^p (press shift key+6 for this ^ and use small p)
give Replace with as : , (Comma)
click on Replace all

Thats it
Click to expand...

I have been using this method for a while and it works great.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top