| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab name in a cell?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
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 "JHJ" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)
Vaya con Dios, Chuck, CABGx3 "JHJ" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
That's good info. Thanks!
"Paul B" wrote: 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 "JHJ" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
Thanx !
"CLR" wrote: =MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99) Vaya con Dios, Chuck, CABGx3 "JHJ" wrote: 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
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 "JHJ" wrote in message ... That's good info. Thanks! "Paul B" wrote: 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 "JHJ" wrote in message ... 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
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 On Fri, 13 Oct 2006 11:19:01 -0700, CLR wrote: =MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99) Vaya con Dios, Chuck, CABGx3 "JHJ" wrote: 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in a cell?
Interesting....thanks for pointing that out Gord.
Vaya con Dios, Chuck, CABGx3 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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 On Fri, 13 Oct 2006 11:19:01 -0700, CLR wrote: =MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99) Vaya con Dios, Chuck, CABGx3 "JHJ" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
