| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet name in a cell
Is there a way to bring the name of the worksheet into a cell on the worksheet?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheet name in a cell
Debra Dalgleish shares how:
http://contextures.com/xlfaqFun.html#SheetName KevinR wrote: Is there a way to bring the name of the worksheet into a cell on the worksheet? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheet name in a cell
Use a formula like
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) In this formula, use the word "filename" as shown. Don't substitute the actual file name. The reference A1 can be any cell -- it doesn't matter. The name of the sheet on which that cell resides will be returned. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 18 Mar 2009 14:44:10 -0700, KevinR wrote: Is there a way to bring the name of the worksheet into a cell on the worksheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheet name in a cell
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31)
On Mar 19, 2:44*am, KevinR wrote: Is there a way to bring the name of the worksheet into a cell on the worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
| copy a sum in cell on sheet 1 (not formula) to cell on sheet 2 | Excel Worksheet Functions | |||
| Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr | Excel Worksheet Functions | |||
| Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
Linear Mode
