| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking cell to filename
Hello there,
I found the following to put the worksheet filename in a cell. =MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename ",A1 ))-FIND("[",CELL("filename",A1))-1) This works just fine. However, I was wondering if there's any way to hide the file extension? I need the extension viewable in my folders, so I have it turned on. But I don't need it to appear in my worksheet. Any help would be appreciated! -Ky |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| cell value as a filename | Excel Discussion (Misc queries) | |||
| substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
| =cell("filename",a1) | Excel Worksheet Functions | |||
Threaded Mode
