J
JHJ
Is there a way to insert a tab name - or the file name - into a cell? I know
that I can put either in the header or footer.
Thanx,
John J.
that I can put either in the header or footer.
Thanx,
John J.
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.
P
Paul B
John, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
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
--
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
CLR
=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
J
JHJ
That's good info. Thanks!
Paul B said:John, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
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
J
JHJ
Thanx !
CLR said:=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)
Vaya con Dios,
Chuck, CABGx3
JHJ said:Is there a way to insert a tab name - or the file name - into a cell? I know
that I can put either in the header or footer.
Thanx,
John J.
P
Paul B
Your welcome
--
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
--
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
G
Gord Dibben
Chuck
Have a read at Bob Phillips' site about the dangers of not adding a cell
reference in your formula.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben MS Excel MVP
Have a read at Bob Phillips' site about the dangers of not adding a cell
reference in your formula.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben MS Excel MVP
=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)
Vaya con Dios,
Chuck, CABGx3
JHJ said:Is there a way to insert a tab name - or the file name - into a cell? I know
that I can put either in the header or footer.
Thanx,
John J.
C
CLR
Interesting....thanks for pointing that out Gord.
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
Gord Dibben said:Chuck
Have a read at Bob Phillips' site about the dangers of not adding a cell
reference in your formula.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben MS Excel MVP
=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)
Vaya con Dios,
Chuck, CABGx3
JHJ said:Is there a way to insert a tab name - or the file name - into a cell? I know
that I can put either in the header or footer.
Thanx,
John J.