If you have addresses in Col A then
enter this in B1
=A1 & ";"
and copy the formula down.
You can then copy column B and paste in TO or BCC field.

Alternatively
enter this in B1
=A1

and this in B2
=B1 & ";" & A2
and copy down

You will get your list in the last cell in Col B


"Dea" wrote:

I want to create a contact list using email addresses of all my friends. I
have about 20 email address going down colum A in Excel. How can I add the
symbol ";" to the end of each email address simultaneously so I dont have to
do it one at a time. I want to be able to copy the list and paste it in my
email so I can send them all a message a one time such as "Happy New Year!"