Forum Discussion
Solved
Insert current file name only
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?
eddymalcs Perhaps like this?
=SUBSTITUTE(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1),".xlsx","")
2 Replies
eddymalcs Perhaps like this?
=SUBSTITUTE(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1),".xlsx","")- Thank you, that works well.
