Cell value as filename
 

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 a
cell value. Is there a way to remove the file extension. Example
"filename.xls" to "filename"?

Please let me know.


--
chas975
------------------------------------------------------------------------
chas975's Profile: http://www.excelforum.com/member.php...o&userid=34530
View this thread: http://www.excelforum.com/showthread...hreadid=542997

Cell value as filename
 

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

Vaya con Dios,
Chuck, CABGx3


"chas975" wrote:


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 a
cell value. Is there a way to remove the file extension. Example
"filename.xls" to "filename"?

Please let me know.


--
chas975
------------------------------------------------------------------------
chas975's Profile: http://www.excelforum.com/member.php...o&userid=34530
View this thread: http://www.excelforum.com/showthread...hreadid=542997