C
chas975
It worked, thanks
=MID(CELL("filename",A2),FIND("[",CELL("filename",A2))+1,SUM(FIND({"[";"]"},CELL("filename",A2))*{-1;1})-1)
_Pascal__wrote back with this formula as a way to put the filename as
cell value. Is there a way to remove the file extension. Exampl
"filename.xls" to "filename"?
Please let me know
=MID(CELL("filename",A2),FIND("[",CELL("filename",A2))+1,SUM(FIND({"[";"]"},CELL("filename",A2))*{-1;1})-1)
_Pascal__wrote back with this formula as a way to put the filename as
cell value. Is there a way to remove the file extension. Exampl
"filename.xls" to "filename"?
Please let me know