John

There is a problem associated with your formula.

Use this instead.

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

To see the reason for adding the cell reference see Bob Phillips's site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP


On Mon, 29 Oct 2007 15:25:00 -0700, John Bundy (remove)
wrote:

After saving the workbook

=RIGHT(CELL("filename"),(LEN(CELL("filename"))-FIND("]",CELL("filename"))))