View Single Post
  #2   Report Post  
KL
 
Posts: n/a
Default

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.