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?
Bookmarks