This code
Code:
--------------------
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
--------------------
works almost perfect for my needs; however, I need it to drop the
extension to where only the name of the name of the file is left.
Any thoughts?
Thanks!
--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile:
http://www.excelforum.com/member.php...o&userid=35267
View this thread:
http://www.excelforum.com/showthread...hreadid=555713