Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

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
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Matt Pinkston
Matt Pinkston

ASKER

SWEET!!!!!