insert a comma in multiple fields
 

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

insert a comma in multiple fields
 

can you provide an example of your data?

On 12 Gru, 18:06, gmkane wrote:
i have a row of email addresses and want to insert a comma in order to cut
and paste into a outgoing email

insert a comma in multiple fields
 

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


"gmkane" wrote:

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

insert a comma in multiple fields
 

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.

"gmkane" wrote in message
...
i have a row of email addresses and want to insert a comma in order to cut
and paste into a outgoing email