place a comma after every word

C

craigs

I have a list :

car
bar
top
list
bin
funny
time
this

I need to have a comma after each word--

car,
bar,
top,
list,
bin,
funny,
time,
this,


Thanks
 
M

moe10134

You could try this:

=CONCATENATE(A1)(", ")(A2)(", "), etc. Then copy column and Paste
Values.
 
D

Don Guillett

for each c in selection
c.value=c & ","
next c


to put together

for each c in selection
mylist= mylist & c & ","
next c
msgbox mylist
 
Top