Cell value as filename

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
 
C

CLR

=MID(CELL("filename",A2),FIND("[",CELL("filename",A2))+1,FIND(".",CELL("filename",A2))-5)

Vaya con Dios,
Chuck, CABGx3
 
Top