C
cindi
Can I create a formula in a cell that will equal the
sheet tab name?
Thanks,
Cindi
sheet tab name?
Thanks,
Cindi
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.
M
Max
Put in say, A1*:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
(This'll extract the sheetname into A1.
But you need to save the file first)
*can be any cell in the sheet
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
(This'll extract the sheetname into A1.
But you need to save the file first)
*can be any cell in the sheet
P
Paul B
Cindi, try this, file must be saved first for it to work
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
C
Cindi
Thank you! Thank you! Thank you!
Cindi
Cindi
-----Original Message-----
Put in say, A1*:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,32)
(This'll extract the sheetname into A1.
But you need to save the file first)
*can be any cell in the sheet
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Can I create a formula in a cell that will equal the
sheet tab name?
Thanks,
Cindi
.
C
cindi
Thank you! Thank you! Thank you!
Cindi
Cindi
-----Original Message-----
Cindi, try this, file must be saved first for it to work
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
Can I create a formula in a cell that will equal the
sheet tab name?
Thanks,
Cindi
.
M
Max
You're welcome, Cindi !
B
Bob Phillips
anchor it
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
HTH
RP
(remove nothere from the email address if mailing direct)
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
HTH
RP
(remove nothere from the email address if mailing direct)
Paul B said:Cindi, try this, file must be saved first for it to work
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
cindi said:Can I create a formula in a cell that will equal the
sheet tab name?
Thanks,
Cindi