+ Reply to Thread
Results 1 to 6 of 6

action to delete

  1. #1
    Registered User
    Join Date
    01-19-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    4

    action to delete

    Hello

    I have a huge Excel database of 10000 email addresses, and in order to import them in to my email accounts address book, I need to remove the the persons name so I am just left with the email address.

    ie;

    (All in one cell)
    John Smith <johnsmith@help.co.uk>

    needs to become

    <johnsmith@help.co.uk>

    I am wondering if there is an action or something that I can run so I don't have to delete each name by hand more than 1000 times?

    Hope someone can help.

    Kind Regards

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: action to delete

    TRY THIs
    select this cell go to EDIT > Fill < Series > justify Click ok
    Does it make sence?

    This should separate the addresses in this cell into many rows
    Last edited by contaminated; 01-19-2010 at 07:53 AM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Registered User
    Join Date
    01-19-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: action to delete

    The email addresses are confidential but it basically looks like this - all in one column.

    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>
    John Smith <johnsmith@help.co.uk>

    x 10000

  4. #4
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: action to delete

    try this
    Assuming the cells are all in Column A.

    Enter this formula in another column

    =RIGHT(A1,LEN(A1)-FIND("<",A1)+1)

  5. #5
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: action to delete

    Hi
    take a look at this workbook

    HTH
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-19-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: action to delete

    AMAZING the forumula worked! Saved me hours! thanks so much :-)

+ 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