Copying partial cell to another cell in OpenOffice Calc

Posted by Justin on Super User See other posts from Super User or by Justin
Published on 2011-05-28T19:50:07Z Indexed on 2012/10/06 9:40 UTC
Read the original article Hit count: 244

Filed under:

openoffice.org

Cell A1 says 0001 John Smith Cell A2 says 0002 Bill Snyder

I want to basically split this, so one column just shows the numbers (0001, 0002, etc.) and then another column just shows the name.

The first part is easy. Using the function "=LEFT(A1;4)" I can get 0001. How can I grab the name? Using "RIGHT(A1;99)", for example, will grab the entire string "0001 John Smith". Since each name is different in length, I'm not sure what to do. Can I somehow tell it to grab the whole string EXCEPT the first 4 characters? Or somehow tell it to grab the last 2 WORDS instead of a number of characters like it's asking?

Related posts about openoffice.org

apt-get is broken

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I Cannot install any package in the server, As I am newbie in Server. In Morning I found that some, I am not able to install any package from command line in the server,Now every package is now manually downloaded packages and then installed in the server. Can any one Please tell me what is the issue… >>> More
Install OpenOffice for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOffice headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
Install OOo for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOfficle headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
How to recover dpkg from corrupted downloads?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I just upgraded to the 10.10 RC earlier and had a few problems with graphic drivers (x didnt start) But i have remedied that now. When i run 'sudo apt-get install -f' i get this: will@UbuntuBox:/mnt/slax$ sudo apt-get install -f [sudo] password for will: Reading package lists... Done Building dependency… >>> More
Programmatically convert *.odt file to MS Word *.doc file using an OpenOffice.org basic macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a reStructuredText to MS Word document tool-chain, so I will be able to save only the rst sources in version control. So far I -- Have rst2odt.py to convert reStructuredText to OpenOffice.org Writer format. Next I want to use the most recent OpenOffice.org (currently 3.1) that… >>> More

Developer IT