Column Header to = Saved File's Title

Is it possible have a column update, so that it shows the exact title of the saved file?

Example:

Column A1 would read "Workbook1," once it was saved as "Workbook1."

I'm thinking some sort of if statement, however, I do not know what the true value would equate to...

I'm lazy and have to do a ton of different workbooks, so this would be cool if it is possible.

Thanks

Try this in the cell of choice:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2)

Use:

=SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2), ".xls", "")


If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.