How to turn a vertical list in excel into a horizontal csv?

Don
Joined
21 Oct 2002
Posts
46,828
Location
Parts Unknown
I've got a file like this


name1
name2
name3
name4


I want to turn it into

name1, name2, name3, name4


How do I do this in Excel? (or any other program)
 
Ah, I was copying from notepad to excel and not seeing the extra Paste Special options

Had to copy from within Excel to get that option

Thanks
 
Thanks for the tip, I didn't know you could do that.

I know you can copy a 'tab' in notepad (and notepad2) and replace it with a comma
 
Back
Top Bottom