Name Cell or Worksheet

[JPA]

Is it possible to use the function "cell" to access only the name of the
worksheet, instead of the whole path?

Formula--> =CELL("filename";A1)
Result--> C:\My Documents\[Table.xls]Sheet2

Result expected--> Sheet2

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is it possible to use the function "cell" to access only the name of the
| worksheet, instead of the whole path?
|
| Formula--> =CELL("filename";A1)
| Result--> C:\My Documents\[Table.xls]Sheet2
|
| Result expected--> Sheet2
|

 

[Gord Dibben]

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

For more on this subject see Bob Phillips' site.

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


Gord Dibben MS Excel MVP