+ Reply to Thread
Results 1 to 4 of 4

List of Email Addresses that I need to Concatenate into one cell

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Indpls, IN
    MS-Off Ver
    Excel 2010
    Posts
    14

    List of Email Addresses that I need to Concatenate into one cell

    I've got a list of over 170 names in excel rows that I need to quickly turn into a copy and paste list that I can mass email some of my sales people.

    Example:
    Amyp@emailaddress.com
    Treverp@emailaddress.com

    I need to combine the names and separate by a semi colon: Amyp@emailaddress.com; Treverp@emailaddress.com

    I started a concatenate formula, but because each name is on different row, it was a lot of manual formula tweaking.

    How do I do this the smart way?
    Last edited by amyp22x3; 01-17-2013 at 03:42 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,333

    Re: List of Email Addresses that I need to Concatenate into one cell

    If you're up for a VBA solution, you could use this UDF from TigerAvatar:

    http://www.excelforum.com/tips-and-t...geravatar.html


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: List of Email Addresses that I need to Concatenate into one cell

    Hi - Assuming your data starts from A1 till A171, use the below formula in cell B1:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The in cell B2 and all the way below (till B171) use this formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Now copy the cell in B171 and paste it as value in any other cell, ex. B172. Now you would be able to copy cell B172 and paste into your composed email's "To" section.

    Hope this helps...
    If solved kindly remember to mark Thread as solved.
    Click the small star icon at the bottom left of my post if this was useful.

  4. #4
    Registered User
    Join Date
    08-01-2012
    Location
    Indpls, IN
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: List of Email Addresses that I need to Concatenate into one cell

    kbkumar,

    That's essentially what I ended up doing, but I was wondering if there was a different way. It didn't take me nearly as long as I thought.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1