Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to convert a hyperlink to its target full-text URL
I have a large excel sheet where one column contains hyperlinks. They are all of the form:
Map_This and I'd like to substitute the underlying URL so that I can save this to a text file and put it in a database. Anyone have an idea? What I don't want to do is to do them all manually by right-clicking, editing the link and cutting and pasting the URL in the "display as". I tried making a macro, but I can't figure out how to make a macro that works in all columns as opposed to just a single cell. TIA. ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
how to hyperlink text to a cell | New Users to Excel |