Need formula to remove text outside of parenthesis

[bighedstev]

I have emails copied to Excel that look like:

Email Owners Name (email address); Email 2 Owners name (email address 2); Email 3 Owners Name (email address 3); ect ect for about 500 email addresses total. When copied from the distribution list in Outlook and pasted into Excel, they're all in the same cell.

I need to extract only the email addresses and remove the names and parenthesis. Can anyone help with this? Mucho Gracias!

 

[BenMiller]

I have emails copied to Excel that look like:

Email Owners Name (email address); Email 2 Owners name (email address 2); Email 3 Owners Name (email address 3); ect ect for about 500 email addresses total. When copied from the distribution list in Outlook and pasted into Excel, they're all in the same cell.

I need to extract only the email addresses and remove the names and parenthesis. Can anyone help with this? Mucho Gracias!

Do you mean that all of your information is in the same cell? Or each individual combination is in a cell? Also, will you have any other parentheses in the cell besides for these two?

 

[BenMiller]

If your data is in A1 try this in B1 =MID(A1,FIND("(",A1)+1,(FIND(")",A1)-FIND("(",A1))-1)

 

[bighedstev]

If your data is in A1 try this in B1 =MID(A1,FIND("(",A1)+1,(FIND(")",A1)-FIND("(",A1))-1)

Thanks for posting this so quickly. That worked for only the first email address and deleted the others.

All of the information is in the same cell. It's one really long string of names with the email addresses in parenthesis and each person separated by a ;

 

[BenMiller]

Ok. First do a Text To Columns with a ; as your delimiter. The highlight your data (not the whole row; just cells with data in them), hit CTRL+C, then select A2 and right-click, choose paste special, and click transpose.

Then use the formula I gave you.

 

[bighedstev]

Ok. First do a Text To Columns with a ; as your delimiter. The highlight your data (not the whole row; just cells with data in them), hit CTRL+C, then select A2 and right-click, choose paste special, and click transpose.

Then use the formula I gave you.

You da man! That worked perfectly. Thank you so much for your help.

 

[BenMiller]

You da man! That worked perfectly. Thank you so much for your help.

No problem Glad I could help Appreciate the feedback!

 

[renanpoco]

Thank you for the tip, I finally solve one of my spreadsheets biggest headaches. Do you know how to create another line for words detach by a comma as for example line 13, columns B and C, where we have "bear (male)" and "bear (female)" detached by a comma ?

https://www.dropbox.com/s/tm4rgnnma9onuyh/memrise english.xlsx?dl=0



Thanks !

 

[Michael M]

This is a 6 year old thread so you may not get the reponse you wanted.
However, what result did you expect from

bear (male), bear (female)

 

[renanpoco]

Actually in Hebrew those words are different and I need to put them in different lines in order to bulk add them properly on memrise website. I'm sorry if the given example sound to childish. Could you help me do that ? Thanks