Try the following formula:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

The file must have been saved for this to work.

Also, please ask your question in the body of the message, not
the subject line. Subject lines get truncated.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"mdeanda" wrote in message
...