Hi,

Use the following formula:

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

You can concatenate the above formula with other text(s), to create a title
that incorporates in it the name of the worksheet;
e.g.,

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

Regards,
B. R. Ramachandran

"ceemo" wrote:


mm i name my sheets tabs according to date example

31-1
1-2
2-2
etc

can i extract this info using a formula to create a titla for my repot


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=507757