Hi Sloth,
Try this:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))
Note: this formula will work if your workbook has been saved at least once.
Regards,
KL
"Sloth" wrote in message
...
I want to make a cell that outputs the name of the worksheet.
|