![f0047-02.jpg](https://article-imgs.scribdassets.com/6zva1fzj5sarg8pp/images/fileNH2Z9J90.jpg)
ONLYOFFICE
Use new formulas to split spreadsheet cells
![f0047-01.jpg](https://article-imgs.scribdassets.com/6zva1fzj5sarg8pp/images/fileLXGNRODX.jpg)
OnlyOffice 7.3 (released in January) includes a set of new formulas that were already available in Microsoft Excel. Two of these formulas make it much easier to chop unwanted text from cells: TEXTBEFORE and TEXTAFTER. As its name suggests, TEXTBEFORE keeps only the text before a character or word you specify, while TEXTAFTER keeps only the text after this point.