Columns to comma separated list?

[dikkill]

Hi,

Anyone know how can i modify a column of keywords to comma separated keyword list?Manually will take ages .

 

[Panther28]

look up concatenate,

 

[PrinceVisi]

Using a Mouse Macro.

Do the first one by yourself and leave the rest to the mouse.

 

[Gogol]

You can do that in excel. Do as mentioned here:

http://superuser.com/questions/240858/convert-a-column-into-a-comma-separated-list

 

[Panther28]

Using a Mouse Macro.

Do the first one by yourself and leave the rest to the mouse.

dude, if neg rep was possible i would power slam u through the floor! lol, thats a terrible idea

 

[Gogol]

Hahaha lol

#fifteenchars

dude, if neg rep was possible i would power slam u through the floor! lol, thats a terrible idea

 

[dikkill]

You can do that in excel. Do as mentioned here:

http://superuser.com/questions/240858/convert-a-column-into-a-comma-separated-list

dude, if neg rep was possible i would power slam u through the floor! lol, thats a terrible idea

You guys are the bomb

Using a Mouse Macro.

Do the first one by yourself and leave the rest to the mouse.

Nice method, you tried lol.

 

[ija61]

Really..?!!!!!!!

 

[divok]

in notepad plusplus , Press ctrl+f and choose extended mode . Replace \n with , .

 

[ziplack]

i use this lil soft

http://download.cnet.com/CSVed/3000-2351_4-52868.html

You add your csv file (comma separated) and the software export it to excel format (tab)

regarts

 

[seosky]

Using a Mouse Macro.

Do the first one by yourself and leave the rest to the mouse.

Yes it will work.

 

[ija61]

i use this lil soft

http://download.cnet.com/CSVed/3000-2351_4-52868.html

You add your csv file (comma separated) and the software export it to excel format (tab)

regarts

I will say it again.. Really?

Did you ever try open the excel and then go to "import from text"?

 

[Gogol]

Yupp that's a cool option too. Shud do it in one click.

in notepad plusplus , Press ctrl+f and choose extended mode . Replace \n with , .