I need a formula to extract the last two words in a cell using openoffice. For example a cell contains the words: "enjoy the rest of your day" I would like to extract "your day" using a formula. I know how to extract the last word:
=RIGHT(A1;LEN(A1)-FIND("*";SUBSTITUTE(A1;" ";"*";LEN(A1)-LEN(SUBSTITUTE(A1;" ";"")))))
which results in "day". But i need a formula for the last two words.
SEARCH supports regular expressions, so use
=RIGHT(A1, LEN(A1) - SEARCH("[^ ]+ +[^ ]+$", A1) + 1)
When I use semicolons as below, Calc silently substitutes commas, but the OP reports success entering it this way:
=RIGHT(A1; LEN(A1) - SEARCH("[^ ]+ +[^ ]+$"; A1) + 1)
I need a formula to extract the last two words in a cell using openoffice. For example a cell contains the words: "enjoy the rest of your day" I would like to extract "your day" using a formula. I ...
I have a WSGI application that generates invoices and stores them as PDF. So far I have solved similar problems with FPDF (or equivalents), generating the PDF from scratch like a GUI. Sadly this ...
Here is a sample application that creates a Window with a single Button inside. When clicked, it connects to OOo (if not already connected) and creates a text document. This works fine unless all ...
It is possible to use Microsoft Word to spell chek an arbitrary document. What I want is to use OpenOffice.org to do the same. Is it possible? How?
I have to maintain a huge set of training material in forms of slides. At a first glance, I ve noticed there s no support for version control in OpenOffice OOImpress (but I might be wrong on this). ...
Each block contains 3 addresses - name, city, state, zip - how do I break it apart in OpenOffice/Excel? James R. Javier DDS Kent R. Nelson DDS Theodore G. Lund DDS 421 SW 335th St 1911 SW Campus Rd ...
I have a small application that generates three different template documents in OOo Writer. When one of the three "generate" buttons is clicked, this is part of the code that is executed (in C#): // ...
I need to develop a service able to convert MS Office and Open Office documents to PDF. And the PDF`s also need to be commentable when opened in ADOBE Reader. I have used a piece of software from www....