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