JRCook2003
New Member
- Joined
- Mar 19, 2003
- Messages
- 29
I have a list of hyperlinks in an Excel workbook. For example, in cell A1, I have "State of Alaska". If I click on that, it brings me to say "http://www.alaska.com"
What I want to do, in cell B1, is to have the "http://www.alaska.com" text/hyperlink....Is there a function that pulls the actuall url from the name of the hyperlink?
Thanks
What I want to do, in cell B1, is to have the "http://www.alaska.com" text/hyperlink....Is there a function that pulls the actuall url from the name of the hyperlink?
Thanks