I have an Excel sheet I need to use in OOo but I am having trouble with one 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 this to work.. If anyone has a suggestion I would appreciate it.