find email address in a cell

[Guest]

I have a file with 65000 rows of data (extracted from email inbox)

I applied a formula to identify which rows had an address
=IF(COUNTIF(A1,"*@*"),"","email")
then a second one to remove the email with our company name
I am left with less than 200 rows
Example: "From: Mail Delivery Subsystem <[email protected]>"

What formula can I apply to get: (e-mail address removed) ?

 

[Ron Rosenfeld]

From: Mail Delivery Subsystem <[email protected]>

IF the email address is the only content that is enclosed in angles (<...>)
then this should work:

=MID(A1,FIND("<",A1)+1,FIND(">",A1)-FIND("<",A1)-1)
--ron