G
Guest
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.
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.