OT: OOo Calc Formula

[Robert Bell]

>
> =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)