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 10:58:05 -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]>
• 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

This is what I tried. Replaced ] with #$ and the , with ;

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

• Follow-Ups:
  • Re: OT: OOo Calc Formula
    • From: Robert Bell

• References:
  • OT: OOo Calc Formula
    • From: Robert Bell

• Prev by Date: OT: OOo Calc Formula
• Next by Date: Re: Antivirus
• Previous by thread: OT: OOo Calc Formula
• Next by thread: Re: OT: OOo Calc Formula
• Index(es):
  • Date
  • Thread