Copying column of email addresses to send

I have a column of several hundred email addresses which I need to copy and paste into an email I am composing. I need to add a "," comma at the end of each email inside each cell of the column. Is there a simple way to do this?

You could use a helper column

Say A1 is the start of your e-mail addresses then in B1 enter

=A1&","

then drag down formula. Then paste special values.

Or

if they all end in say .uk you could select the column and press Ctrl + H. Find would be .uk and replace would be .uk,

VBA Noob

Thanks I knew it was something simple like that I just haven't learned every shortcut yet.