Outlook E-mail Addresses in Excel

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

I inherited an Excel file with 985 email address in them. The problem is
that they exist in Excel as hyperlinks, which when clicked on launch a new
Outlook email.
I need to send all these email address to an outside vendor. How can I
convert all these hyperlinks to a column of email address (such as
(e-mail address removed)).
Thank you
Carl
 
I inherited an Excel file with 985 email address in them. The problem is
that they exist in Excel as hyperlinks, which when clicked on launch a new
Outlook email.
I need to send all these email address to an outside vendor. How can
I convert all these hyperlinks to a column of email address (such as
(e-mail address removed)).
Click to expand...

Probably better to ask in Excel, since they'll know more about the data manipulation
than we would, but, the hyperlinks, are they just user@domain or are they
friendly names?
 
Back
Top