How to Extract URL from Hyperlinked Cell in Excel

[winatiga]

i'm from 6 years later after you post this. thanks!

[Mister.Psychology]

It works and it's amazing as very few Excel users know how to explain even simple stuff. But please never link to your site and make users go there to finish the lecture. Sites shut down.

[vivianfoster]

I tried 4 different tutorials before I found this one and yours worked for me. Thank you!!

[Ms_GypsySoul]

Damn you're GOOD!!!! Ive looked high and low and could not find anything to work. Im a subscriber NOW!!!!

[fishingpissed]

Thank you so much. Had been trying to do this all morning with google sheets. Just copied and pasted it into Excel and your trick worked like a charm <3

[JCdiedUall]

Thank you for the help Here is the text of the code:

Function GetURL(pWorkRng As Range) As String
GetURL =
End Function

[littlemspd]

Wow, this is the best video I could find and the easiest. Thank you so much!

[BigPoppaLay]

You just saved me hours of work today. Thanks Ryan!

[talhahabib]

Thanks you so much. it saved so much time for me

[rumpeldumpel]

Very helpful, saved me loads of clicking, thanks very much!

[IsabelleRo]

Wow, thank you! I've searching for this since a long time too.

[lorddabu]

This real nice. Is there a Google sheets version of this function? That would be real nice. All I've seen is how to extract links from the hyperlink formula, but not this way.

[rodneyfong]

Thanks, Ryan. It works great...save me a lot of time from copy and pastes.

[FerraPizza]

Saved me about an hour ... thanks mate

[johnlorenzoalipio]

Thank you so much YAN S. HUANG... you're so brilliant!!!

[mj]

Great Video! Thanks Yan - it's a great help. The link to your blog is broken?

[nounix]

Is there any way to get rid of (disable) the annoying warning when clicking on a hyperlink that links to a file (video/photo/doc) on your OWN disk, which says "some files can contain viruses or otherwise be harmful to your computer ... would you like to open this file?"? I just want to click on the link and have the file directly open, without having to go through this extra step of authorizing excel to open the file. Is this possible to disable on a Mac (Excel 2019 for Mac)?

[rockonyo]

Take a look at this tool Excel URL Validator;It automatically extracts URLs, Validates and saves clean reports in a separate file. It also supports batch processing .

[NyxView]

Please help with the below error while importing data.
"Resource at URL contents exceeded maximum size."

[lenutaursachi]

Thanks for the tutorial! Really good! The link doesn't work but it was helpful the screenshot from the video.