You will need to do some parsing to get the filename out, but this will give
you the whole reference of the path, filename and sheet

=CELL("Filename")

This give you just the filename

=MID(CELL("Filename"),FIND("[",CELL("Filename"),1)+1,(FIND(".",CELL("Filename") ,1)+4)-(FIND("[",CELL("Filename"),1)+1))

(Beware the wrap above)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"JKaz" wrote in message
...
I want to display the file name in a cell in the workshett