| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
insert sheet tab name on the spreadsheet, not in the header
Excel - I would like to refer to the sheet tab name on the spreadsheet...I
know you can use the simple (tab) command in the header, but what would be the "formula" you would put in a cell to refer to the sheet tab name...ie ={tab}? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert sheet tab name on the spreadsheet, not in the header
Use the following formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) The file must have been saved to disk for this to work. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "donaldD" wrote in message ... Excel - I would like to refer to the sheet tab name on the spreadsheet...I know you can use the simple (tab) command in the header, but what would be the "formula" you would put in a cell to refer to the sheet tab name...ie ={tab}? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert sheet tab name on the spreadsheet, not in the header
That did it...Awesome....
"Chip Pearson" wrote: Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) The file must have been saved to disk for this to work. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "donaldD" wrote in message ... Excel - I would like to refer to the sheet tab name on the spreadsheet...I know you can use the simple (tab) command in the header, but what would be the "formula" you would put in a cell to refer to the sheet tab name...ie ={tab}? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert sheet tab name on the spreadsheet, not in the header
This works, but cuts off the rest of the filename and xls extention.
I want the cell to contain (example): ftx07715s-1/31/05 as the filename contains a date. Thanks. "donaldD" wrote: That did it...Awesome.... "Chip Pearson" wrote: Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) The file must have been saved to disk for this to work. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "donaldD" wrote in message ... Excel - I would like to refer to the sheet tab name on the spreadsheet...I know you can use the simple (tab) command in the header, but what would be the "formula" you would put in a cell to refer to the sheet tab name...ie ={tab}? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert sheet tab name on the spreadsheet, not in the header
This does work but would you explain this formula to me. Is there a website
that will breakdown the formula to explain it to me? "Chip Pearson" wrote: Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) The file must have been saved to disk for this to work. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "donaldD" wrote in message ... Excel - I would like to refer to the sheet tab name on the spreadsheet...I know you can use the simple (tab) command in the header, but what would be the "formula" you would put in a cell to refer to the sheet tab name...ie ={tab}? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert sheet tab name on the spreadsheet, not in the header
Hi
=CELL("Filename",A1) will return something like C:\Data\[Sales.xls]Sheet1 FIND("]",CELL("filename",A1)) will return the position of the ] within the string (position 19) MID(the number returned from above+1,32) will return that portion of the string starting 1 character after the position of the ], (20) and return the next 32 characters i.e. Sheet1 The number of characters to pick up could be set at any arbitrary number that is likely to be greater than the length of the sheet name. -- Regards Roger Govier "esparzaone" wrote in message ... This does work but would you explain this formula to me. Is there a website that will breakdown the formula to explain it to me? "Chip Pearson" wrote: Use the following formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) The file must have been saved to disk for this to work. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "donaldD" wrote in message ... Excel - I would like to refer to the sheet tab name on the spreadsheet...I know you can use the simple (tab) command in the header, but what would be the "formula" you would put in a cell to refer to the sheet tab name...ie ={tab}? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert the same header in every sheet in a excel workbook | Excel Discussion (Misc queries) | |||
| Macro with a different Header for each Sheet | Excel Discussion (Misc queries) | |||
| How can I complete a spreadsheet using macros? | Excel Worksheet Functions | |||
| How can I complete a spreadsheet using macros? | Excel Discussion (Misc queries) | |||
| How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Hybrid Mode
