| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Cell or Worksheet
Is it possible to use the function "cell" to access only the name of the
worksheet, instead of the whole path? Formula-- =CELL("filename";A1) Result-- C:\My Documents\[Table.xls]Sheet2 Result expected-- Sheet2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name Cell or Worksheet
=RIGHT(A1,LEN(A1)-FIND("]",A1))
-- Kind regards, Niek Otten Microsoft MVP - Excel "JPA" wrote in message ... | Is it possible to use the function "cell" to access only the name of the | worksheet, instead of the whole path? | | Formula-- =CELL("filename";A1) | Result-- C:\My Documents\[Table.xls]Sheet2 | | Result expected-- Sheet2 | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name Cell or Worksheet
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
For more on this subject see Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Sat, 10 Nov 2007 01:14:01 -0800, JPA wrote: Is it possible to use the function "cell" to access only the name of the worksheet, instead of the whole path? Formula-- =CELL("filename";A1) Result-- C:\My Documents\[Table.xls]Sheet2 Result expected-- Sheet2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell from one worksheet to another worksheet in exel | Excel Discussion (Misc queries) | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Linear Mode
