Forum Discussion
Solved
File Name
Hi There, What kind of formula should I use to have the excel file name in a cell WITHOUT the extension of the file, Thanks, Ali
Alireza2291 Perhaps this:
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND(".xlsx",CELL("filename"))-FIND("[",CELL("filename"))-1)It assumes that the extension you seek is ".xlsx" since you are working in an Excel file. If you are on a recent version you can avoid the receptive references to CELL() by using the LET function.
I think you need to provide a little more information here. For example, where is file name coming from? Do you have a whole column of file names, including their extensions, and just want to strip off the extensions? And so forth. The answer to your question is probably fairly easily--Excel can readily do text manipulation--but it would help if you could provide a bit more info on the circumstances in which you want to remove the extension(s).