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
).
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
).

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?

--
f.h.
Microsoft Outlook MVP