| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Hyperlink display
I have the file path to several files of mine in columb A.
In columb B, I use =hyperlink(A1) and copy down. The hyperlinks work fine but I only want to display the actual file name. example instead of - G:\Staff Duty Book Folders V2\Book Cover.doc I want it to display - Book Cover Any suggestions I am totally lost on this. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display the full file path for a hyperlink in Office 2003 | Excel Discussion (Misc queries) | |||
| How to hyperlink to an image on a different sheet and display it f | New Users to Excel | |||
| Hyperlink to a location on worksheet and display full image. | Excel Discussion (Misc queries) | |||
| Hyperlink display text maximum in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I display hyperlink in Excel cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
