Error in formula to show sheet name

I'm using this formula to show the sheet name in a cell in each worksheet.

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

The problem is if I name the sheet with a number only (no text) it adds a "+0" at the end of the formula. Then if I change the name of the worksheet to a text it give me the error "#value!".

Any suggestions?

It might be easier to just create this UDF:

Please Login or Register  to view this content.