ExcelBanter - Cell value = sheet name

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell value = sheet name (https://www.excelbanter.com/excel-discussion-misc-queries/20488-cell-value-%3D-sheet-name.html)

anonymous

Cell value = sheet name

What's the formula to put the sheet name into a cell?

Thank you,

MB

Peo Sjoblom

Workbook needs to be saved first

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34)
--
Regards,

Peo Sjoblom

"anonymous" wrote in message
...
What's the formula to put the sheet name into a cell?

Thank you,

MB

JE McGimpsey

take a look he

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
"anonymous" wrote:

What's the formula to put the sheet name into a cell?

Thank you,

MB

All times are GMT +1. The time now is 03:21 PM.