| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
Hyperlink display
=HYPERLINK(A1,MID(LEFT(A1,FIND(".",A1)-1),MAX(ROW(INDIRECT("1:"&LEN(A1)
))*(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\"))+1, 255)) entered as an array formula with Ctrl+Shift+Enter. It assumes there will be at least one "\" in the file name and a . in only the file name part. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
| 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
