| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Hyperlink-show link
Thanks Mike-that worked "Mike H" wrote: 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" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i link Excel to Powerpoint slide show & see graph on wk she | Charts and Charting in Excel | |||
| Excel - Hyperlink, the link gets Corrupted | Excel Worksheet Functions | |||
| How do I show the address of hyperlink to another cell in Excel ? | Excel Discussion (Misc queries) | |||
| Excel- Hyperlink or link | Excel Discussion (Misc queries) | |||
| How to link a document to a workbook with a hyperlink in excel | Excel Worksheet Functions | |||
Hybrid Mode
