How do I insert a date created in a cell in excel?

[Hasta]

I am trying to insert the file name in a cell. I don't want the entire path,
just the file name. Please help!

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Niek Otten]

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

--
Kind regards,

Niek Otten

Microsoft MVP - Excel