Hi. I have a list of email addresses in Excel 7.0a that I need to format in order to use them in my email program. The addresses appear in a column like so:
mike@yahoo.com
ted@sbcglobal.net
aaron@comcast.net
I need to combine these emai addresses so they have semi-colons and one space separating them, so that they read:
mike@yahoo.com; ted@sbcglobal.net; aaron@comcast.net
Then I'll cut and paste them into my email message.
What is the best way to do this? Thank you so much for your help!
~Ali
mike@yahoo.com
ted@sbcglobal.net
aaron@comcast.net
I need to combine these emai addresses so they have semi-colons and one space separating them, so that they read:
mike@yahoo.com; ted@sbcglobal.net; aaron@comcast.net
Then I'll cut and paste them into my email message.
What is the best way to do this? Thank you so much for your help!
~Ali