| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Reference
Is there a function in Excel to display the Worksheet Name in a cell?
-- Regards, John Salemi, Jr, CPA, MST |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary worksheet reference to detail worksheet | New Users to Excel | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Linear Mode
