I have copied and pasted a web page into Excel. One of the cells came in as a link but it only shows the friendly text, not the URL behind it. The URL does come up when I hover over the link but that doesn't help me.
If the link is in A1, what formula can I put in B1 to extract the URL from that link?
Can it be done without using a custom function and if so, how?
If a function is needed, can you provide the function with clear instructions on how to add it into Excel 2007 (never done this before).
Thanks for your help!!!
If the link is in A1, what formula can I put in B1 to extract the URL from that link?
Can it be done without using a custom function and if so, how?
If a function is needed, can you provide the function with clear instructions on how to add it into Excel 2007 (never done this before).
Thanks for your help!!!