Hi

this is an answer posted by Chip Pearson to a similar question awhile back:
---
If the current workbook is C:\Temp\Test.Xls and the sheet is Sheet1,


Use
=CELL("filename",A1)
to get the full name, including the sheet name. E.g.,


C:\Temp\[Test.Xls]Sheet1
Use
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("fil
ename"
,A1))-FIND("]",CELL("filename",A1)))
to get just the sheet name
Sheet1


Use


=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL
("file
name",A1))-FIND("[",CELL("filename",A1))-1)
to get just the file name
Test.Xls

Use
=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))
to get full name without sheet name


C:\Temp\[Test.xls]
Use
=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FI ND("]",CELL("filenam
e",A1)
)),"[",""),"]","")
to get full name without sheet name, and without square brackets
C:\Temp\Test.Xls


In all of the formulas above, you can use any cell instead of A1 --
just use a cell that is on the same sheet as the cell containing the
formula.


Cordially,
Chip Pearson
---

Cheers
JulieD

"mariusz" wrote in message
...
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