| Edit | Tech | | Notes |
|---|
 | MSSQL | | SQL Performance Hint | | Shopping | | DEstroy the myth | | Shopping | | | | WEB | | | | DEV | | | | DEV | | | | Shopping | | Another example of why Open Source is a bad Idea from the onset. There is noone to provide a fix to these design flaws. | | WEB | | | | excel | | Answer: Below is a function that you can include in your spreadsheet to extract the hyperlink address from a cell in Excel.
Function HyperLinkText(pRange As Range) As String
Dim ST1 As String
Dim ST2 As String
If pRange.Hyperlinks.Count = 0 Then
Exit Function
End If
ST1 = pRange.Hyperlinks(1).Address
ST2 = pRange.Hyperlinks(1).SubAddress
If ST2 <> "" Then
ST1 = "[" & ST1 & "]" & ST2
End If
HyperLinkText = ST1
End Function
Then you can reference this new function in your spreadsheet.
For example in cell B1, you could enter the following:
=HyperLinkText(A1)
| | WEB | | |
|
|
|
|