name of tab into a cell

A

Andy B.

Hi

In excel I want to put the name of the tab into the cell onto the shee
(eg Sheet 2)

Can someone let me know a formula to do this

Than
 
P

Paul B

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 from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
 
J

Jim Rech

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 from 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 the 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
| >
|
|
 
Top