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

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

--
HTH

Bob Phillips

"Hasta" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
>I am trying to insert the file name in a cell. I don't want the entire
>path,
> just the file name. Please help!

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
>I am trying to insert the file name in a cell. I don't want the entire
>path,
> just the file name. Please help!