Insert current file name only

[eddymalcs]

I am using the formula 

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

to insert the file name into a cell.

I would like this to work without inserting the .xlsx suffix. How can this formula  be modified to achieve that please?

[#2 · Accepted solution]

@eddymalcs Perhaps like this?

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

[#3]

Thank you, that works well.