find email address in a cell
 

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 "

What formula can I apply to get: ?

find email address in a cell
 

On Tue, 24 Jul 2007 09:00:04 -0700, Frederique
wrote:

From: Mail Delivery Subsystem

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