N NotGood@All Feb 13, 2009 #1 How would I make a row say something + the name of the file. Like "This Workbood belongs to" + the name of the workbook "Mike.xls
How would I make a row say something + the name of the file. Like "This Workbood belongs to" + the name of the workbook "Mike.xls
M Mike H Feb 13, 2009 #2 Hi, ="This workbook belongs to "&MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) All in on line Mike
Hi, ="This workbook belongs to "&MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) All in on line Mike
