I am trying to use a function to auto add the filename to a cell. I went to
http://www.xldynamic.com/source/xld.xlFAQ0002.html for advice and got what i
was looking for. The only problem i am having is the extension is coming up
also. Is there to get rid of it? So if the filename is test.xls, I just want
test to show. I am using the function below.

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

Thanks,
Steve