View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HarryNYC
 
Posts: n/a
Default Convert Hyperlink into URL

hey guys... I have a long single-column sheet of urls which are displayed as
€śfriendly_name€ť hyperlinks (blue & underlined)€¦ what I need are the
€ślink_location€ť url addresses instead€¦ I tried €ścopy€ť then €śpaste special€ť
but no luck€¦ and the command €śremove hyperlink€ť simply converts the hyperlink
into text and loses the url all together€¦ any ideas? Thanks!