Re: [libreoffice-users] Insert the filename in a cell

I solved it with this formula:

=REPLACE(REPLACE(CELL("filename");FIND(".";CELL("filename");1);(LEN(CELL("filename"))-FIND(".";CELL("filename");1)+1);"");1;SEARCH("/[^/]*$";
CELL("filename"));"")

I like it!

On Fri, Oct 19, 2012 at 4:06 PM, Jay Lozier <jslozier@gmail.com> wrote:

> On 10/19/2012 08:41 AM, Samuele Zampini wrote:
>
> > Dear All,
> >
> > I am trying to insert in a cell (let's say A1) the file name (without the
> > path and - if possible - without the extension).
> >
> > I have tried this<http://office.microsoft.**com/en-us/excel-help/**
> > inserting-the-current-excel-**file-name-in-a-cell-**HA001034627.aspx<http://office.microsoft.com/en-us/excel-help/inserting-the-current-excel-file-name-in-a-cell-HA001034627.aspx>
> > > ,
> >
> > but it does not work: Err.501 appears.
> >
> > Could you help?
> >
> > Thanks a lot,
> > Samuele
> >
> >  Please post the formula you are using and typical path/file name you are
> using.
>
> --
> Jay Lozier
> jslozier@gmail.com
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org <users%2Bhelp@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted