[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: OT: OOo Calc Formula





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


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]