Displaying worksheet name in cell

[Adrian]

Is there any way to display a worksheet name in a cell (without using macros).

I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all end up
displaying the same name!

 

[Dave Peterson]

Include a reference to each sheet:

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

Is there any way to display a worksheet name in a cell (without using macros).

I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all end up
displaying the same name!

 

[Paul Sheppard]

Is there any way to display a worksheet name in a cell (without usin
macros).

I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all en
up
displaying the same name!

Hi Adrian

Try this >

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

 

[Adrian]

Thanks, this worked great

Is there any way to display a worksheet name in a cell (without using
macros).

I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all end
up
displaying the same name!

Hi Adrian

Try this >

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

 

[Adrian]

Thanks, this worked great

Include a reference to each sheet:

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

Is there any way to display a worksheet name in a cell (without using macros).

I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all end up
displaying the same name!