ExcelBanter - Worksheet name in a cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Worksheet name in a cell (https://www.excelbanter.com/excel-worksheet-functions/73750-worksheet-name-cell.html)

Charlie

Worksheet name in a cell

I am attempting to get a cell to return the worksheet name. I am certain
there is a function that should do this, but I haven't found it. Any help is
appreciated.

Thanks,

Charlie

Duke Carey

Worksheet name in a cell

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)

"Charlie" wrote:

I am attempting to get a cell to return the worksheet name. I am certain
there is a function that should do this, but I haven't found it. Any help is
appreciated.

Thanks,

Charlie

Charlie

Worksheet name in a cell

Duke,

That is great! Many thanks and God bless.

Charlie

"Duke Carey" wrote:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)

"Charlie" wrote:

I am attempting to get a cell to return the worksheet name. I am certain
there is a function that should do this, but I haven't found it. Any help is
appreciated.

Thanks,

Charlie

All times are GMT +1. The time now is 05:31 AM.