Extract Mail Address from String

[fastrack1]

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?

[Richard Schollar]

Hi

Assuming your email in A1 try:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"(",REPT(" ",100)),")",REPT(" ",100)),100,100))

and copy down.

Richard

[DonkeyOte]

fastrack1,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

On this occasion I have modified for you - going forward please endeavour to follow the above guidelines.

[broro183]

hi all,

Here's a little something I've been playing with recently to help extract emails from messy database dumps which may have the emails in a number of separate columns etc.

It is "work in progress" & needs to be optimised (esp the Redim within a loop & perhaps to use a paramarray) but I thought I would post it "as is" since it ties in with the subject of this thread (thanks to DO's editing)

Please Login or Register  to view this content.

hth
Rob

[fastrack1]

Hi

Assuming your email in A1 try:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"(",REPT(" ",100)),")",REPT(" ",100)),100,100))

and copy down.

Richard

Richard, thanks so much!! It worked great and has saved this ignorant soul from a ton of work