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
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
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
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
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
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.