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

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



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

Sorry,

for the sheet name, use:

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


Mangesh



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



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

Hi,

Define [b]X[/]

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

In the cell,

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

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=392422

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

Regards
Rowan

"JaneC" wrote:

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

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

--
HTH

Bob Phillips

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