ExcelBanter - Worksheet Reference

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

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

- - Worksheet Reference (https://www.excelbanter.com/excel-worksheet-functions/187429-worksheet-reference.html)

jtscpa

Worksheet Reference

Is there a function in Excel to display the Worksheet Name in a cell?
--
Regards,

John Salemi, Jr, CPA, MST

Teethless mama

Worksheet Reference

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

"jtscpa" wrote:

Is there a function in Excel to display the Worksheet Name in a cell?
--
Regards,

John Salemi, Jr, CPA, MST

Soundar

Worksheet Reference

Hi,

You can display the worksheet name in the cell using the below formula.

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))

But before using this one, u need to save.

Regards,
Soundar.

"jtscpa" wrote:

Is there a function in Excel to display the Worksheet Name in a cell?
--
Regards,

John Salemi, Jr, CPA, MST

All times are GMT +1. The time now is 12:05 PM.