FYI, the reference to A2 is not necessary:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Jim Rech
Excel MVP
| Andy, try this, will return sheet name:
| =MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,255)
| file must be saved first
|
| --
| Paul B
| Always backup your data before trying something new
| Please post any response to the newsgroups so others can benefit fro
it
| Feedback on answers is always appreciated!
| Using Excel 2000 & 2003
|
| | >
| > Hi
| >
| > In excel I want to put the name of the tab into the cell onto th
sheet
| > (eg Sheet 2)
| >
| > Can someone let me know a formula to do this
| >
| > Thank
| >
| >
| > --
| > Andy B.
|
------------------------------------------------------------------------
| > Andy B.'s Profile:
|
http://www.excelforum.com/member.php?action=getinfo&userid=14764
| > View this thread:
http://www.excelforum.com/showthread.php?threadid=275575
| >
|
|
