insert a comma in multiple fields

G

gmkane

i have a row of email addresses and want to insert a comma in order to cut
and paste into a outgoing email
 
S

Sheeloo

Are your addresses in A1, A2,... or A1, B1, C1,...?

Assuming they are in Col A
enter this in B1
=A1
and this in B2
=B1 & "," A2 and copy down till end of your data

In the last cell of Col B you will get your addresses separated by comma

If you have data in Row 1
then in A2 enter
=A1
in B2 enter
=B1 & "," & A2 and copy right...
 
F

Fred Smith

Say your addresses are in row 2.
In row 3 enter:
=A2&","
and copy across

Now copy the entire row and paste it into your e-mail program. Outlook (at
least) will accept the paste as multiple e-mail addresses, and process
accordingly. If you have another e-mail program, hopefully, it will too.

Regards,
Fred.
 
Top