Sheet:

=REPLACE(CELL("Filename",A1),1,SEARCH("]",CELL("Filename",A1)),"")

File, without the path:

=REPLACE(REPLACE(CELL("Filename",A1),SEARCH("]",CELL("Filename",A1)),255,""),1,SEARCH("[",CELL("Filename",A1)),"")

mariusz wrote:
Hello!

Is there any formula which put name of sheet to cell on the sheet?
And very similar question:
Is there any formula which put name of file to any sheet?
I have to do something like above but without using VBA.

Thanks in Advance
Mariusz