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

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

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

--
HTH

Bob Phillips

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

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

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