One way

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34)


you need to have saved the workbook

--

Regards,

Peo Sjoblom


"Matt" wrote in message
...
I just want the cell to give the title of the sheet. For example: Sheet
1
would be displayed in A2 if A2 had this function.