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

Try this:
http://www.officearticles.com/excel/...ft_e xcel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"ceemo" wrote in
message ...

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

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