Computing.Net > Forums > Office Software > Adding commas to email addresses in

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Adding commas to email addresses in

Reply to Message Icon

Name: Aperryman
Date: February 5, 2009 at 11:13:41 Pacific
OS: Macintosh
Subcategory: Microsoft Office
Comment:

Does anyone know how to simply add a comma to each email
address in a column of email addresses? I have to email from
gmail so I can't format as a hyperlink! thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: February 5, 2009 at 12:13:01 Pacific
Reply:

Where is this list? In Outlook? You mention g-mail, yet your Subcategory is Microsoft Office. What program are you using?

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


0

Response Number 2
Name: DerbyDad03
Date: February 5, 2009 at 12:19:56 Pacific
Reply:

Are we talking about a column of text in an Excel spreadsheet? If so...

Let's say A1 contains:

me@mymail.com

1 - In B1 put =A1&","
2 - Drag this down to the end of your data.
3 - Highlight Coulmn B and do Copy...Paste Special - Values



0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Adding commas to email addresses in

formatting email addresses in Excel www.computing.net/answers/office/formatting-email-addresses-in-excel/5083.html

email addresses in Excel www.computing.net/answers/office/email-addresses-in-excel/6999.html

Stop email address spell-checking www.computing.net/answers/office/stop-email-address-spellchecking/5002.html