View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ttc ttc is offline
external usenet poster
 
Posts: 1
Default Change hyperlink name to url

In excel I have a long list of hyperlinks to favorite places on the web. I
want to print the url addresses. When I turn off the hyperlink only the
"friendly name" is left. Is there a way to change the friendly name to the
url address without manually typing or right clicking/edit hyperlink and then
copying the url for each one?
Thanks!