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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Re-title multiple MS Project .mpp files at once 0
FILE NAME AS TEXT 1
List all tables, including document structure 0
Adding a big matrix in Word 2013 5
Word VBA - Want to test if Full Name is NOT Present in document 0
Integrating information from Word to Excel (not mail merge) 1
Merging from an Excel file with graphics 1

Top