How to Insert the current Excel file name, path, or worksheet in a cell !?

How to Insert the current Excel file name, path, or worksheet in a cell !?

1--Puna putanja / path:

=CELL("filename", A1) 

vraća punu putanju, naziv datoteke i naziv trenutnog lista u Excelu, uz uvjet da je radna knjiga spremljena.

2--Samo naziv datoteke:
=MID(CELL("filename", A1), SEARCH("[", CELL("filename", A1)) + 1, SEARCH("]", CELL("filename", A1)) - SEARCH("[", CELL("filename", A1)) - 1)

3--Samo naziv datoteke i naziv lista:
=RIGHT(CELL("filename", A1), LEN(CELL("filename", A1)) - FIND("]", CELL("filename", A1)))

🔊 WARNING !!!   NAPOMENA !!! 🔊
WPS Office (and Excel configured with European regional settings) uses a semicolon (;) instead of a comma (,) to separate function arguments.

Ova gore NAPOMENA znači da je potrebno sve zareze (,) zamijeniti sa točka zarez (;) u slučaju kada je vaš EXCEL postavljen sa "European regional settings".  

Npr. tada formula br.2 glasi:

=MID(CELL("filename";A1);SEARCH("[";CELL("filename";A1))+1;SEARCH("]";CELL("filename";A1))-SEARCH("[";CELL("filename";A1))-1)

https://professor-excel.com/file-name-sheet-name-path-insert-file-information-excel-cell/