Hi, Can anyone help with how to return filenames in cells? Thanks. Neil Holmes.
N Neil Holmes Dec 19, 2003 #1 Hi, Can anyone help with how to return filenames in cells? Thanks. Neil Holmes.
P Peo Sjoblom Dec 19, 2003 #2 One way =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3) assuming you are using one period in the file name like in *.xls
One way =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".", MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3) assuming you are using one period in the file name like in *.xls
