Hi all,

I have read the article that excel can auto insert the file name in a cell
using this:
=LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".",
MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3)

which, for example, will return "abc.xls" in the cell if the file name is
abc.xls

If i want the cell to show "abc" only (without the extension xls) is there a
way to do so?

Thanks!

--