Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |