Forum Discussion
File Name
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.
Alireza2291 If you need only file name in a cell WITHOUT the extension & path, below is the formula
=RIGHT(LEFT(CELL("filename"),(SEARCH(".",(CELL("filename"))))-1),LEN(LEFT(CELL("filename"),(SEARCH(".",(CELL("filename"))))-1))-(SEARCH("[",(LEFT(CELL("filename"),(SEARCH(".",(CELL("filename"))))-1)))))
paste the above formula in any cell
save the workbook with any name and close it
open it and you will see the file name without extension
attached are sample files, save them on your computer & open it you will see the result
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.
- Thank you so much sir,
- Sir, your formula is good as it is short.
In my formula you need not to bother about the length of extension.
My formula will handle both .xls as well as .xlsxOn the other hand your formula doesn't work if the file is synced with OneDrive/SharePoint folder.
Riny_van_Eekelen formula works with both extensions if change *.xlsx on *.xls. And both for synced and not synced folders.
