Solved: Formula for sheet name

[mdmackillop]

Maybe it's just a bad day, but I can't recall a method (other than UDF) to return the sheet name to a cell within it, or more specifically the last 2 characters of the sheet name.

[Bob Phillips]

The sheet name is

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

therfore the last 2 chars are

=RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),2)

remember this only works on workbooks that have been saved.

[mdmackillop]

Thanks Bob.
I knew there was a function there somewhere.