Excel Filename in cell without the ".xls" extension

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!



--

See one answer in m.p.excel

Please don't post to multiple groups - it just tends to fragment your
answers and to potentially waste the time of those replying to questions
that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm

In article ,
"John Smith" wrote:

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!

See John McGimpsey's reply in microsoft.public.excel