I'm storing this info here so I can find it later. I have a spreadsheet with a lot of URLs stored in a column (more than 150). The URLs are embedded in files stored on a remote server so when you click on the file it will take you to the file.
Great, except I need the actual hyperlink info. I could get the URL by right clicking then cutting/pasting each file, but that would take hours. So I need a custom function or macro to extract them for me.
The basic info is copied from this location:
How to create a custom function
That's all good and fun, but it doesn't tell me how to create a custom function. So, here's another source:
BEFORE YOU PROCEED, you will need to go into your Excel settings and, in the File > Options you need to edit the Auto correct setting that automatically turns URLs into hyperlinks.
BTW: I am not copying this here to rip off anybody's content. I'm just storing it here in case the original links ever go away.