Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sry... Yes I posted it twice as my computer looked like it timed out... I
should have checked Thanks "Jacob Skaria" wrote: What about your previous post..??? Try the below formulas in a saved workbook 'Workbook and worksheet name =MID(CELL("filename",A1),FIND("[",CELL("filename",A1)),99) 'workbookname =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) 'worksheet name =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") If this post helps click Yes --------------- Jacob Skaria "Curtis" wrote: Is there a formula that would allow the name of a workbook or worksheet to show in a cell inside a worksheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|