Sheet name in a cell
How can I put the name of the sheet in a cell automatically?
Thank you!
iMac 27″ 5K, macOS 10.15
Question marked as
Top-ranking reply
If by "automatically" you mean by formula, then, yes, you can put a name in a cell that will change automatically when you change the name of the table or sheet.
For a sheet name in cell A2:
=TEXTBEFORE(REFERENCE.NAME(A2,2,reference-style),"::")
For a table name in cell A3:
=TEXTBETWEEN(REFERENCE.NAME(A3,2,reference-style),"::","::")
(use ; instead of , in the formulas if your region uses , as a decimal separator)
SG