M
MIKE
How can I see the shett tab name in a spreadsheet cell of that sheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Naveen
Please try this ...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
*** Please do rate ***
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
*** Please do rate ***
C
CLR
Note, if this formula appears not to work, then save the file first before
using it, then it works fine.
Vaya con Dios,
Chuck, CABGx3
using it, then it works fine.
Vaya con Dios,
Chuck, CABGx3
Naveen said:Please try this ...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
*** Please do rate ***
MIKE said:How can I see the shett tab name in a spreadsheet cell of that sheet?
B
Bob Phillips
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)