Filename

J

Jai

Hi,

I am using formula "=cell("filename")" to show filename and full path of the
file. Is there any extent of this formula to show only filename not the full
path of the file?

Please answer.
Thanks
 
B

Bob I

Yes you will need to trim the "path" off the front end. See expression
below and watch the word wrap.

=MID(CELL("filename"),LEN(INFO("directory"))+1,LEN(CELL("filename"))-LEN(INFO("directory")))
 
J

Jai

Hi Bob,

Thanks for the reply,
I used the formula you advised, however its coming with "value".
Please help.
Thanks
Jai
 
Top