Re: OT: OOo Calc Formula

To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>
Subject: Re: OT: OOo Calc Formula
From: Robert Bell <robert@xxxxxxxxxxxxxxxxx>
Date: Fri, 09 Sep 2005 11:19:53 -0700
In-reply-to: <[email protected]>
List-archive: <https://www.redhat.com/archives/fedora-list>
List-help: <mailto:[email protected]?subject=help>
List-id: For users of Fedora Core releases <fedora-list.redhat.com>
List-post: <mailto:[email protected]>
List-subscribe: <http://www.redhat.com/mailman/listinfo/fedora-list>, <mailto:[email protected]?subject=subscribe>
List-unsubscribe: <http://www.redhat.com/mailman/listinfo/fedora-list>, <mailto:[email protected]?subject=unsubscribe>
References: <[email protected]> <[email protected]>
Reply-to: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041206 Thunderbird/1.0 Mnenhy/0.7.1

=RIGHT(CELL("filename",A1);SUM(LEN(CELL("filename",A1))-SEARCH("#$",CELL("filename",A1);1)))

got it:

=RIGHT(CELL("filename";A1);LEN(CELL("filename";A1))-FIND("#$";CELL("filename";A1))-1)

References:
- OT: OOo Calc Formula
  - From: Robert Bell
- Re: OT: OOo Calc Formula
  - From: Robert Bell