Separate keyword list in notepad with comma

Hi all,

Is there such tools that can separate keywords list in notepad format(txt) with commas?

Example (in notepad):

make money online
make money with internet
how to make money
fastest way to make money

Convert to:

make money online, make money with internet, how to make money, fastest way to make money

Any suggestion?

Thanks in advance

 

i haven't found way to do this thing in excel. I did it manually, I put my fingers in "," "delete" and "end" lol

 

using excel, concatenating cells: =a1 &"," & b1 &"," & with all cells.

Best regards...

 

I got more than 10,000 words that's gonna sore.. LOL..

 

Thanks dtodo, I found the solution already more less like what you suggested..

 

If you need, I can write one for U.

 

hi could u tell here whats the solution u found out..even i am having the same problem

 

Its quite simple actually. Open your MS excel then follow the follow in the image below:



Formula is =A2&","&A3



Formula is =B3&","&A4

Then drag the B4 column down - This will automatically put all the commas in place.

Hope this help

 

Hi thanks for the lightening fast response , will try it and get to u soon

cheers

 

You can use Notepad++ and replace '\n' to ','.

I use Notepad++ for blogging and development. It has all basic features of editor. It is simple and fast.
See 10+ Notepad++ Tips For Fast Development

 

Sounds like a great idea and organised