View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Excel Contains E-mail Addresses

I inherited an Excel 2003 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, displayed as John Doe in Excle, to a column of
email address (such as ).
I posted in an Outlook group and an Outlook MVP thought I might be better
posting this question here.
Thank you
Carl