View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CT3or4 CT3or4 is offline
external usenet poster
 
Posts: 4
Default formula or code to extract hyperlink from displayed text

Huge Excel files (& files) with 'text dislayed' (long descriptions) as
hyperlink that need to be converted to URL (http://etc) hyperlink in order to
save/use in various apps & dbs.
How can I/we convert or extract the URL in in the cell without using the
"Edit Hyperlink" tool one-cell-at-a-time to cut, paste?
--
CT3or4