In agreement with Chip's recommendation, and to facilitate using only one
cell, you could enter Ardus's formula like this:

=MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)

Regards,
GS