What happened when you tried it? What e-mail program are you using?

A program like Outlook is smart enough to put the separator in by itself.
You just copy the column and paste it in the "To:" box.

Another option is to add the semi-colon in Excel. In another column, use:
=a1&";"
Copy this down
Now copy and paste this column into the e-mail.

Regards,
Fred

"Mrs. Mc" <Mrs. wrote in message
...
I want to copy a column from an excel sheet and paste it directly to the
address on an email.... How do I make the tthe semicolons appear?