Excel Hyperlink-show link

[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

 

[Mike H]

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

 

[KMA-VLD]

Thanks Mike-that worked

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