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!
|