=REPLACE(CELL("filename",A1),1,SEARCH("]",CELL("filename",A1)),"")

Bene wrote:
I'd like to use the worksheet name to automatically adjust calculations in
the worksheet.

I know that it's possible to return the full file name using
CELL("filename") and feel sure that there must be a similar option for just
the worksheet name.

Can anyone help?

Many thanks.