Using Sheeloo's formula, try this

Select B2 to B21, assuming that row one is your header row and B21 is your
last row of email address.
place in this formula into the formula bar

=A2&"; "
press Ctrl and Enter together, this will automatically add a "; " to all the
email addresses you have at one stroke.

I leave a space for the next email address which normally is the case

Does this do what you want?

HTH

--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis



"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!"