OT: OOo Calc Formula

To: Fedora List <fedora-list@xxxxxxxxxx>
Subject: OT: OOo Calc Formula
From: Robert Bell <robert@xxxxxxxxxxxxxxxxx>
Date: Fri, 09 Sep 2005 10:54:02 -0700
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>
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

I have an Excel sheet I need to use in OOo but I am having trouble withone formula. In excel this will return the Sheet Name:


=RIGHT(CELL("filename",A1),SUM(LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1),1)))

Now I know the delimiter in OOo is #$ not ] but I cant seem to get thisto work.. If anyone has a suggestion I would appreciate it.