Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to put Worksheet Name in a Cell
I'd like to be able to include the name of each worksheet in the body
of the worksheet without having to type it in each time. Is there a way to use a formula to tell Excel to do this. I've used =cell("filename",a1) in the past to get the filename in the worksheet, but I can't find a similar formula for the worksheet name itself. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to put Worksheet Name in a Cell
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
-- Gary''s Student - gsnu200721 "DC Excel User" wrote: I'd like to be able to include the name of each worksheet in the body of the worksheet without having to type it in each time. Is there a way to use a formula to tell Excel to do this. I've used =cell("filename",a1) in the past to get the filename in the worksheet, but I can't find a similar formula for the worksheet name itself. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to put Worksheet Name in a Cell
Gary might have mentioned the formula returns #VALUE! until you do a save
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "DC Excel User" wrote in message ups.com... I'd like to be able to include the name of each worksheet in the body of the worksheet without having to type it in each time. Is there a way to use a formula to tell Excel to do this. I've used =cell("filename",a1) in the past to get the filename in the worksheet, but I can't find a similar formula for the worksheet name itself. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to put Worksheet Name in a Cell
On May 12, 2:45 pm, "Bernard Liengme"
wrote: Gary might have mentioned the formula returns #VALUE! until you do a save best wishes -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email "DC Excel User" wrote in oglegroups.com... I'd like to be able to include the name of each worksheet in the body of the worksheet without having to type it in each time. Is there a way to use a formula to tell Excel to do this. I've used =cell("filename",a1) in the past to get the filename in the worksheet, but I can't find a similar formula for the worksheet name itself. Thanks.- Hide quoted text - - Show quoted text - Thank you. This worked perfectly -- I should have thought of this solution. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to put Worksheet Name in a Cell
On May 12, 2:20 pm, Gary''s Student
wrote: =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) -- Gary''s Student - gsnu200721 "DC Excel User" wrote: I'd like to be able to include the name of each worksheet in the body of the worksheet without having to type it in each time. Is there a way to use a formula to tell Excel to do this. I've used =cell("filename",a1) in the past to get the filename in the worksheet, but I can't find a similar formula for the worksheet name itself. Thanks.- Hide quoted text - - Show quoted text - Thank you so much. Perfect solution! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? | Excel Worksheet Functions | |||
Cell reference in different worksheet in formula | Excel Worksheet Functions | |||
How do I populate a worksheet name in a formula using a cell ref. | Excel Discussion (Misc queries) | |||
What is the formula to reference a cell in a different worksheet? | Excel Worksheet Functions | |||
Can I use a formula to get the worksheet name into a cell? | Excel Worksheet Functions |