We often want to write the name of worksheet in the cell. At first glance, it should be a trivial solution but not (yet). Hopefully at there will be a simple solution in one of the following versions. Below see the solutions.
Looks like this formula that returns a worksheet
name in a cell. In cell A1, enter the function =CELL("filename";A1);
which shows us the full file path and name of the sheet. “NiceSheetName” is the
name of the sheet.
This is a shorter variant.:
= RIGHT (A1); LEN (A1))-FIND ("]";
A1)) the following formula is references in cell A1, but the formula entered
complete.
