Re: OT: OOo Calc Formula

[Robert Bell <robert@xxxxxxxxxxxxxxxxx>]

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