View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eli[_4_] Eli[_4_] is offline
external usenet poster
 
Posts: 14
Default Extract email(s) from address field

So I have a list of address, where the entire address is in one cell, I want
to extract just the email address from the field. Here is a quick example:

A B

1 555 A St

Everywhere, USA



2 557 A St

Everywhere, USA

3



So column A is the information I have (some address have multiple email
address), and column B is what I want. Any ideas?

Thanks