How to add a file name with .xls extension in Microsoft Excel cell

[AdilShaikh18]

I know that I can enter a cell file name with the following typed into the cell: =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1). But, can I do this without showing the file extension (.xls).

[GALIENA]

Maybe something like this. =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH(".xl?]",CELL("filename"))-SEARCH( [",CELL("filename"))-1).

[QUENBY]

I also found that this works as well (removes last 4 digits by changing -1 to -5, but I like your solution better: =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5). If still you face issue you can try out some links below. They might not provide you exact info on adding the same but just for reference I am adding it.

Add the file path to Excel worksheet headers and footers

Insert a file name in a header or footer