I know that I can enter a cell file name with the following typed into the cell: =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1). But, can I do this without showing the file extension (.xls).
Bookmarks