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