Formula to display Sheet name

[JaneC]

Hi, Is there a formula I can put in a cell that will show the name of the
sheet it is on? Thanks, Jane

 

[Rowan]

=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)

Regards
Rowan

 

[Mangesh Yadav]

Use:

=CELL("filename",A1)

will give the full path. If you need just the file name, then use:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

Mangesh

 

[Mangesh Yadav]

Sorry,

for the sheet name, use:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1)))


Mangesh

Use:

=CELL("filename",A1)

will give the full path. If you need just the file name, then use:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

Mangesh

Hi, Is there a formula I can put in a cell that will show the name of the
sheet it is on? Thanks, Jane

 

[Bob Phillips]

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

 

[Krishnakumar]

Hi,

Define X[/]

=GET.DOCUMENT(76)&T(NOW())

In the cell,

=MID(X,FIND("]",X)+1,255)

HTH