+ Reply to Thread
Results 1 to 3 of 3

email names

  1. 03-28-2015, 04:02 PM #1
    manceI
    manceI is offline
    Registered User
    Join Date
    02-07-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    38

    email names

    Is there a away to separate email names?

    For example if column "A" is the following:

    [email protected]
    [email protected]
    [email protected]


    can we have column "A" look like
    mabbass@
    nabbatangelo@
    annemi@


    and column "B" look like
    realtyusa.com
    bellmarc.com
    wcarmls.com

    Thanks
    Reply With QuoteRegister To Reply
  2. 03-28-2015, 04:14 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,284

    Re: email names

    =LEFT(A1,FIND("@",A1,1))
    =RIGHT(A1,LEN(A1)-FIND("@",A1,1))
    Try this
    Last edited by popipipo; 03-28-2015 at 04:16 PM.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 03-28-2015, 04:29 PM #3
    manceI
    manceI is offline
    Registered User
    Join Date
    02-07-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: email names

    It was my computer error. That works perfectly. Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding email macro in EXCEL to maintain constant email hyperlink but able to change names.
    By sfskepler in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-23-2014, 07:39 PM
  2. Convert names to email address
    By Meger5 in forum Excel General
    Replies: 4
    Last Post: 03-28-2014, 11:55 AM
  3. Matching email addresses to Names and Last Names
    By ffrriieennddzz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-12-2012, 01:17 PM
  4. Email to a list of names from within worksheet
    By sarails in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-11-2008, 01:47 AM
  5. [SOLVED] add email address to a list of names
    By biochemist in forum Excel General
    Replies: 5
    Last Post: 05-17-2005, 01:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1