Excel Hyperlink-show link

  • Thread starter Thread starter KMA-VLD
  • Start date Start date
K

KMA-VLD

I have an excel databae table which has one column in which each cell reads
"Show Record" and each of these lables has a hyperlink to a different
webpage. I want to export the data to use in Filemaker and when I save as a
text file, I lose the hyperlink. Is there a way to show the URL instead of
the "View Record" or can I create another column in which the hyperlink will
be displayed?

Thanks
 
Hi,


You could use this UDF.
Alt+F11 to open VB editor
Right click 'This Workbook'
Insert Module
Paste this in on the right

Function GetLink(HyperlinkCell As Range)
GetLink = Replace(HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")
End Function

Enter the formula
=GetLink(A1) in a cell to return the underlying address of a hyperlink in
that cell


Mike
 
Thanks Mike-that worked

Mike H said:
Hi,


You could use this UDF.
Alt+F11 to open VB editor
Right click 'This Workbook'
Insert Module
Paste this in on the right

Function GetLink(HyperlinkCell As Range)
GetLink = Replace(HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")
End Function

Enter the formula
=GetLink(A1) in a cell to return the underlying address of a hyperlink in
that cell


Mike
Click to expand...
 
Back
Top