Inserting a Comma in Many Cells
 

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

Inserting a Comma in Many Cells
 

try this on your selection.

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

--
Don Guillett
SalesAid Software

"Ken" wrote in message
m...
How can I insert a comma at the end of each entry in a long column of
e-mail addresses?

Inserting a Comma in Many Cells
 

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)ValueOKEsc.

Delete Column A.

Gord Dibben Excel MVP

On 8 May 2004 14:59:58 -0700, (Ken) wrote:

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