View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Minuette Minuette is offline
external usenet poster
 
Posts: 1
Default Copy text hyperlinks and paste them as source addresses?

I have 1000s of text hyperlinks in a spreadhseet (are these called target
links?) and I want to display them as proper addresses (called source?) You
can see the URL address in the yellow text box that appears when I hover over
the link. Have been unable to find anything in paste special, or in the View
tab in Options to help. Know that there is a Visual Basic way but can't use
it! Help!