Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Need to separate emails from names

  1. #1
    New Member
    Join Date
    Apr 2005
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need to separate emails from names

    I have and excel sheet that was a contact list apparently exported wrong and has the names and addresses all together in each cell in about 350 rows in column A, they are all in this format

    john doe email address here

    for some reason the email address in brackets won't show up here but each email address is in <> brackets

    I need to get the name in one column and the email address without the <> brackets into another, any ideas?
    Last edited by robisc; Jan 28th, 2009 at 10:50 AM. Reason: didn't display sample email address

  2. #2
    MrExcel MVP
    Moderator
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Need to separate emails from names

    If you need to write a lower than symbol < then leave a trailing space immediately after it otherwise it gets interpreted as html and you lose subsequent data (as in your post).

    Try selecting the column and going Data>TextToColumns>Delimited>Other and type in a > characters>Finish

    This should get you most of the way there. Then you can simple Edit>Replace on the email column with a Find of > and leaving Replace blank to get rid of the trailing > in the email names.
    Richard Schollar

    Using xl2013

  3. #3
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Need to separate emails from names

    This perhaps:

    Index

     ABC
    1John Doe <john.doe@nomail.com>John Doejohn.doe@nomail.com

    Spreadsheet Formulas
    CellFormula
    B1=TRIM(LEFT(A1,FIND("<",A1)-1))
    C1=MID(A1,FIND("<",A1)+1,FIND(">",A1)-FIND("<",A1)-1)


    Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  4. #4
    New Member
    Join Date
    Apr 2005
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need to separate emails from names

    Thanks, worked perfectly! This forums is the best and you guys are the best.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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