Extract URLs from Hyperlinks in Excel (2 Easy Ways)

In this video, I will show you how to quickly extract URLs from hyperlinks in Excel using simple VBA codes.

I will cover two methods where you can use a VBA subroutine to extract the URLs in an adjacent column or create a custom function (UDF) that you can use within the worksheet to get the URL from a cell that has a hyperlink.

00:00 Intro
00:18 Extract URLs from Hyperlinks using VBA Subroutine
03:08 Formula to Extract URLs from Hyperlinks

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[IvanCortinas_ES]

As always, excellent explanation. Clear, direct and essential. Thanks Sumit!

[toddb]

I've been looking for this solution for months! This goes in the toolbox. Many thanks for posting.

[rajeevgosavi]

As usual, very nicely explained. We appreciate your skill in making complex things easy to understand. Could you also guide us as to how to convert these URLs into clickable links. Thanks in advance.

[kevine]

Thank you for the clear instructions. I'm subscribed!

[einoconsult]

Thanks Sumit, I like the second method, I hope Microsoft will release a native function for that, but you can check a third method (similar to the first one) from Mark Proctor, @Excel Off the Grid, using Office Scripts

[arcturus]

Getting the compile error when i type . Adress. It says expected identifier or brakceted expression