ExcelBanter - Sheet name in Cell

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

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

- - Sheet name in Cell (https://www.excelbanter.com/excel-discussion-misc-queries/2401-sheet-name-cell.html)

GregR

Sheet name in Cell

How do I get the sheet name in a cell. TIA

Greg

JE McGimpsey

Take a look he

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

In article ,
"GregR" wrote:

How do I get the sheet name in a cell. TIA

Peo Sjoblom

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)

you can put this formula in any cell, even A1

Regards,

Peo Sjoblom

"GregR" wrote:

How do I get the sheet name in a cell. TIA

Greg

GregR

JE and Peo, thank you very much.

Greg
"Peo Sjoblom" wrote in message
...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)

you can put this formula in any cell, even A1

Regards,

Peo Sjoblom

"GregR" wrote:

How do I get the sheet name in a cell. TIA

Greg

All times are GMT +1. The time now is 08:40 AM.