View Single Post
  #1   Report Post  
littleellisdude
 
Posts: n/a
Default Separating an email address embedded in a "mail to:" hyperlink

How can I separate (extract) ALL of the email addresses from a column of
MULTIPLE "email data hyperlinks" when they are all embedded in a "mail to:"
hyperlink? There is only one per row, but about 2000 in the total column.
Doing them one at a time will take a year to extract :o(
Thank you!!!
Example:
clicking on John Doe in a column opens Outlook "mail to:" to the persons
real email address.