Extract URLs from Hyperlinks in Excel (2 Easy Ways)

Рет қаралды 5,036

Күн бұрын

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
You can get the VBA codes from here - trumpexcel.com/extract-url-fr...
If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 17

@trumpexcel 6 ай бұрын

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: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@subhabratade93 5 ай бұрын

Sumitji, mere ko pop up aa raha hai "please select a range" ,but main select kar ke hi code chala raha hum...kaha pe galti ho raha hai? main isko personal workbook main paste kia...usme baki code thik chal raha hain kindly reply

@toddb4609 5 күн бұрын

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

@IvanCortinas_ES 6 ай бұрын

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

@trumpexcel 6 ай бұрын

Thanks from commenting Ivan... I realised this is something I need to do very often. Hope this is helpful for other too

@einoconsult5563 6 ай бұрын

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

@trumpexcel 6 ай бұрын

Glad you found the video helpful... will check out the method you mentioned :)