You're correct, forgot to include the A1.

Thank you!
--
Wag more, bark less


"Gord Dibben" wrote:

Watch it with that particular formula Brad.

With no cell reference it can lead to erroneous returns.

See Bob Phillips' site for more info.

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


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 13:19:01 -0700, Brad
wrote:

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

Success, click yes.

.