Hello !
I am trying to extract the hyperlink from a lot of cells.
I know we can extract manually the URL by editing the link... but this could be done only one at a time (I think ) and I have hundreds to work on
I found few visual basic codes to extract the link... like this one:
Function ExtractURL(rng As Range) As String
On Error Resume Next
ExtractURL = rng.Hyperlinks(1).Address
End Function
I tried other ones but the result is always the same: the link is not copied completely.
This hyperlink is an example: https://fmsqprod.myabsorb.ca/#/online-courses/2a985219
After I applied the formula (=extracURL), all that I get is https://fmsqprod.myabsorb.ca/
Does someone knows how I can get the complete URL ?
Thank you in advance !
I am trying to extract the hyperlink from a lot of cells.
I know we can extract manually the URL by editing the link... but this could be done only one at a time (I think ) and I have hundreds to work on
I found few visual basic codes to extract the link... like this one:
Function ExtractURL(rng As Range) As String
On Error Resume Next
ExtractURL = rng.Hyperlinks(1).Address
End Function
I tried other ones but the result is always the same: the link is not copied completely.
This hyperlink is an example: https://fmsqprod.myabsorb.ca/#/online-courses/2a985219
After I applied the formula (=extracURL), all that I get is https://fmsqprod.myabsorb.ca/
Does someone knows how I can get the complete URL ?
Thank you in advance !