Cell value = tab name?

F

foxgguy2005

is there a formula to put into a cell that will display the tab name in
the cell?
Thanks!
 
M

mangesh_yadav

Try:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Manges
 
Top