You may be able to achieve what you're after by deleting the Hyperlink Address, retaining just the SubAddress. You can do that with a macro using code like:
Code:
Sub Test()
Dim xlWkSht As Worksheet, HLnk As Hyperlink
For Each xlWkSht In ThisWorkbook.Worksheets
For Each HLnk In xlWkSht
With HLnk
.Address = ""
.ScreenTip = .SubAddress
End With
Next
Next
End Sub
Test on a copy of your workbook before doing it on the one you want to use.
PS: A little patience wouldn't go astray. A follow-up less than an hour after the original post isn't likely to endear you to anyone...