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

Hi :)
Congrats!!  Nicely done and thanks for postign the answer back to the list to help people in the 
future.  
Congrats and regards from
Tom :)  





> ________________________________
> From: Samuele Zampini <samuele.zampini@gmail.com>
> To: Jay Lozier <jslozier@gmail.com> 
> Cc: users@global.libreoffice.org 
> Sent: Friday, 19 October 2012, 15:23
> Subject: 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
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