View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mmhoballah mmhoballah is offline
external usenet poster
 
Posts: 2
Default how do I change a hyperlink to text

I have a long column of hyperlinks in an excel file. I need to copy the full
addresses as text into an adjacent column. I can do this line by line thru
Edit Hyperlink Ctrl C / Ctrl V, but this is too tedious. Tried to record my
steps to a macro but macro completely ignored my steps!
Thank you