How to Extract URL from Hyperlinked Cell in Excel
http://yan411.com/video/how-to-extrac... Microsoft Excel has a built in function called HYPERLINK() which allows you to convert a link location (URL) and friendly name (anchor text) into a hyperlinked cell that you can click on to open the link in a web browser window. However, Excel does not have a default function that allows you to do the reverse of that—to extract the URL from a hyperlinked cell. In order to do this, we need to get our hands dirty with some VBA (Visual Basic for Applications) code. Don’t worry, it isn’t too complicated.