View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Michelle
 
Posts: n/a
Default How to Display hyperlink addresses that already exist as links to

How do you do this? Is there a formula? We have a document with 3800 rows
of data. Two of the cells have text in them that link to URLs - we now need
to display the full link address in those cells rather than the text for a
conversion that we're donig. Is there an easier way other than getting the
link properties for each and every hyperlink?