Inserting a Comma in Many Cells

K

Ken

How can I insert a comma at the end of each entry in a long column of
e-mail addresses?
 
D

Don Guillett

try this on your selection.

sub putcomma
for each c in selection
c.value = c & ","
next
end sub
 
G

Gord Dibben

Ken

Assuming addresses in Column A.......

In B1 enter =A1&","

Double-click on the fill handle of B1 to copy down.

When happy with the results, copy Column B and Paste Special(in
place)>Value>OK>Esc.

Delete Column A.

Gord Dibben Excel MVP
 
Top