Bhupinder, try this in a cell, workbook has to be saved first

=MID(LEFT(CELL("filename",A1), FIND("]", CELL("filename",A1))-1),FIND("[",
CELL("filename",A1))+1, 255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Bhupinder Rayat" wrote in
message ...
Is there any way of displaying the filename of the spreadsheet in a cell
within the workbook?

If not then how simple is it to create a user defined function to do this?

Any help would be much appreciated.

Thanks,

Bhupinder Rayat