Using headlers how do I include file but without .xls?

K

Katherine2000

I have been asked to include the file name in the header but so it does not
show the .xls bit at the end. Is there a way I can do this using a automated
funtion?
 
J

JBoulton

Hi,

Try this. It works for me.

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