sheet names

C

ceemo

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 repo
 
B

B. R.Ramachandran

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
 
Top