Maybe something like this?:

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH(".xl?]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I know that I can enter a cell file name with the following typed into the
cell:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

But, can I do this without showing the file extension (.xls)?