Hi all.

I want to insert the name of the current workbook into a cell in my workbook. I got this formula from the Microsoft website, which gives the name of the workbook including the full path:

=CELL("filename")

Then I got this, which takes me a step closer, and gives me just the name of the workbook, including the extension:

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

but what I really need is the name of the current workbook, minus the ".xls" extension from the right-hand side, but also minus 25 characters from the left-hand side. Is this possible? I'm guessing I would have to use the LEN function somewhere (twice) in combination with LEFT and RIGHT, but I can't work it out.