place a comma after every word

  • Thread starter Thread starter craigs
  • Start date Start date
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
 
You could try this:

=CONCATENATE(A1)(", ")(A2)(", "), etc. Then copy column and Paste
Values.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup only part of the string in the cell 3
List comma separated 21
change csv list separator in excel 2007 Dutch version 1
Excel Save As Options 2
Creating a csv 4
CSV to List 7
Ground loop isolator causes loss of audio signal 9
Excel VBA - Force 4 commas into a text field on userform 7

Back
Top