Display part of Worksheets name in a cell.

[DeR]

If I have a worksheet named "c01", can I write a function in a cell on that worksheet that will display the "01" part of the worksheet name?

Thanks
DeR

 

[Dannyh1]

Hi try,


If it always last 2 digits,

=RIGHT(CELL("filename"),2)

 

[DeR]

Thanks,
That works great for my current worksheet (c01), but I do have some worksheets in this workbook that have more characters after the "c", like "c09.1". Is there a way to tell it to take everything after the "c"?

 

[Dannyh1]

maybe:

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("Filename"))-1)

 

[DeR]

Thanks....

That's perfect.