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

[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?

 

[Frank Kabel]

Hi
no, this would only be possible using macros

 

[JBoulton]

Hi,

Try this. It works for me.

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