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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
