EXCEL: sheet name in a cell
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.
For more information please refer to: www.kid.si