Stephane thank you very much for helping me with this question.
Linda

"Stephane Quenson" wrote:

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.