[libreoffice-users] Convert formulae to actual
I have a calc sheet with full names in one column, thus: John Smith Jane Smollett I want to create a column with forenames and one with surnames. I've created an extra column with the position of the space between first name and last name (in the cases above, it's five in each case), and two other columns in one of which I place the first x-1 characters where x is the position of the space) and in the other I place the right end of the name field from the x+1 character to the end. What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Can't find it anywhere. TIA //James -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
Le 21/03/2011 17:59, James Wilde a écrit : What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Select, then Copy Special at the same place with Formula option unchecked. -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On Mar 21, 2011, at 18:10 , Jean-Francois Nifenecker wrote: Le 21/03/2011 17:59, James Wilde a écrit : What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Select, then Copy Special at the same place with Formula option unchecked. Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. //J -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On 2011-03-21 4:14 PM, James Wilde wrote: Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. sure it does, I use it all the time... -- Best regards, Charles -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
Le 21/03/2011 21:14, James Wilde a écrit : Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm there *is* a Formula option :) -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On Mar 21, 2011, at 21:46 , Jean-Francois Nifenecker wrote: Le 21/03/2011 21:14, James Wilde a écrit : Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm there *is* a Formula option :) Ah, thanks. I didn't realise that, by select, you meant I had to copy the cells in question. When I copied them first, it worked exactly as you said. Thanks for the help. //James -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***