Forum Discussion
How can I extract URL from hyperlinks?
I have a worksheet where one column contains hyperlinks (like created with =HYPERLINK(link;text)). How can I create a formula extracting link urls from those hyperlinks? I've tried dozen of search qu...
WORKS RIGHT AWAY; ALL WE HAVE TO DO IS ADD A COLUMN RIGHT OF THE HYPERLINK.
ATEN USE TEXT TO COLUMN OPTION SEPEARTE AND TAG
agrawalr1 can you provide the specific syntax for that? E. G. If the hyperlink is in A1, what is the formula you would type in B1?