| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheetname formula
I am trying to figure out a formula that will result in the name of the sheet
that formula is in. Similar to a =Info(type_text) but that will simply output the name of the sheet. any help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheetname formula
Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Note: the file must already exist. In other words, it must have already been saved with a filename. Biff "John S" <John wrote in message ... I am trying to figure out a formula that will result in the name of the sheet that formula is in. Similar to a =Info(type_text) but that will simply output the name of the sheet. any help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheetname formula
Something like this may work for you.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Regards, Paul "John S" <John wrote in message ... I am trying to figure out a formula that will result in the name of the sheet that formula is in. Similar to a =Info(type_text) but that will simply output the name of the sheet. any help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheetname formula
=CELL("filename",A1)
-- Gary's Student "John S" wrote: I am trying to figure out a formula that will result in the name of the sheet that formula is in. Similar to a =Info(type_text) but that will simply output the name of the sheet. any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
| can formula to read sheetname from a cell? | Excel Worksheet Functions | |||
Linear Mode
