See Bob Phillips' site for the "how" part.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben MS Excel MVP
On Mon, 7 Apr 2008 14:56:19 -0700, Dave wrote:
Could someone please explain to me how the following function works?
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Many thanks - Dave.