Row Title

N

NotGood@All

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

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
 
Top