Excel File extract a URL from a link

I have a excel file (sample attached) column C is an opportunity name, that is linked to a URL. is there a way to create another column that is just the actual URL?
USPS-SItesx.xlsx
Matt PinkstonAsked:
Who is Participating?
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
Here's your example workbook loaded up with an example UDF like shown in the above question.
EE-USPS-SItesx.xlsm
0
 
Glenn RayExcel VBA DeveloperCommented:
No points:  This EE solution should work for you; it involves creating a UDF (user-defined function).

https://www.experts-exchange.com/questions/27766063/Extract-a-URL-out-of-a-hyperlink-in-Excel.html
0
 
Matt PinkstonAuthor Commented:
SWEET!!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.