Formula for name of Sheet
 

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

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

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

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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