Cell Nameing

[Robin thorne]

Is there a way to get a cell to equal the worksheet name?
so if I change the name from sheet 1 to sheet 1a then for
example cell A1 will also change to refect this.

 

[Bob Phillips]

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("fi
lename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1),1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[JE McGimpsey]

One way:

A1: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)