Hard to tell - your formula works for me, though this is a bit more
efficient:

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

I can generate a #NAME! error if I switch the sheet to use R1C1-style
references. In that case the formula should be something like:

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


In article .com,
"bjrbrain" wrote:

Thanks for the suggestion but it doesn't seem to work for me. Keying
this into the cell with an '=' sign just produces a #NAME?

I will say that your solution is much more user friendly than another
one that was suggested:(for when someone else takes over my
spreadsheets):

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

What, pray tell, am I doing wrong in regards to your suggestion?

Thanks again,
Brian