Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add the tab name
Is there a formula that will add the name of the current tab name to a cell?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add the tab name
Antonio,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) file must be saved first You may also want to 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 "AntonioM" wrote in message ... Is there a formula that will add the name of the current tab name to a cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add the tab name
http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "AntonioM" wrote in message ... Is there a formula that will add the name of the current tab name to a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |