Results 1 to 5 of 5

Extract Mail Address from String

Threaded View

fastrack1 Extract Mail Address from... 01-15-2010, 01:05 PM
Richard Schollar Re: Help me create a formula 01-15-2010, 01:14 PM
DonkeyOte Re: Help me create a formula 01-15-2010, 01:21 PM
fastrack1 Re: Help me create a formula 01-15-2010, 02:22 PM
broro183 Re: Extract Mail Address from... 01-15-2010, 02:15 PM
  1. #1
    Registered User
    Join Date
    01-15-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Extract Mail Address from String

    Here is what I need to happen.

    I have this text (1000's of them, but same format) in a column:

    Tim Queen (tim.queen.jrtd@crazymail.com)

    I need to remove the name "Tim Queen" from the beginning and remove the "(" & ")". I want to be left with just the email address.

    How can I do this for 1000's of names at one time?
    Last edited by DonkeyOte; 01-15-2010 at 01:21 PM.

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