Remove text and parenthesis in Excel? -

i have filtered column in excel on 1000 different email addresses , vary in length usernames first , last name. example cell field like:
last name, first name (firstname.lastname@example.com)

i remove users last name, first name , parethesis except email address should firstname.lastname@example.com

i understand how remove length of characters such =left(a2, len(a2)-2) not how remove parenthesis well.

what's function use in cell?

thanks!

try formula

=substitute(mid(a1,find("(",a1)+1,99),")","") 

it finds position of opening parens, grabs right , replaces closing parens empty string.