Outlook E-mail Addresses in Excel

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
[email protected]).
Thank you
Carl
 
F

F.H. Muffman

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
[email protected]).
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?
 
Top