Try in any cell:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
(workbook must be saved first)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"john anderson" <john wrote in message
...
I need a formula to show the tab name only in the spreadsheet. I know how
to
get the file and path name, but that brings up too much information. I
only
want it to display the tab name.