Hi,

Sheeloo's method works but you might be able to use the Replace command if
all the email addresses end with .COM

In that case select all the addresses and press Ctrl+H and enter .Com in the
Find what box and .Com; in the Replace with box and then press Replace All.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


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