Formula to Extract Email Address in Excel

[ashleykate7]

I need a formula to extract an email address from a field. Undelivered email responses were exported from Outlook to an Excel Worksheet. In a new column, I need a formula to extract the email address from the field that contains the body of the undeliverable email address. This is an example of the text:

This message was created automatically by mail delivery software. A message that you have sent could not be delivered to one or more
recipients. This is a permanent error. The following address failed: <johndoe@abc.com>: 550 Mailbox unavailable or access denied - <johndoe@abc.com>

Any help would be greatly appreciated. Thank you!


<TABLE style="WIDTH: 110pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=147><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 5376" width=147><TBODY><TR style="HEIGHT: 409.5pt" height=546><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 110pt; HEIGHT: 409.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" id=td_post_417240 class=xl63 height=546 width=147>





</TD></TR></TBODY></TABLE>

 

[Dannyh1]

Hi Try:


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

 

[BrianExcel]

The easiest (and quickest) way without writing custom code will probably be to use text delimiting.

Use the "Text to Columns" button under the "Data" tab in excel, and when the window opens, choose "delimited', then enter < into the other field in step 2 of 3.

This will get you closer and then from there you can copy and paste values as needed.

 

[BrianExcel]

I stand corrected. Well done Dannyh1.

 

[ashleykate7]

Hi Try:


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

This work great!! Thank you

 

[vivantools]

1. Run Excel Extract Email Addresses
2. Click the "Add Excel File(s)" button to add files. ...
3. Tick "Delete Duplicates After Extraction" to remove duplicate results.
4. To start extracting emails from selected files, click the "Extract Email Address From Excel Files" button.

Read google support page help you : https://support.google.com/mail/thread/65696055?hl=en

Thanks
Kaven