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 <[email protected]> >To: Jay Lozier <[email protected]> >Cc: [email protected] >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 <[email protected]> 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 >> [email protected] >> >> > -- For unsubscribe instructions e-mail to: [email protected] 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
