Excel get filename

The solution for this is noted below

Excel get filename

Solution

' Excel: cell entry (not VBA but for cells)
=LEFT(RIGHT(CELL("filename");LEN(CELL("filename"))-SEARCH("["; CELL("filename"))); SEARCH("."; RIGHT(CELL("filename");LEN(CELL("filename"))-SEARCH("["; CELL("filename"))))-1)

Try other methods by searching on the site. That is if this doesn’t work