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].**
> org <users%[email protected]>
> 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: [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
