EXCEL: sheet name in a cell

Deli s prijatelji:

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

Posted in Uncategorized.