A solution using the REGEX function can be viewed here: (Flat OpenDocument Spreadsheet format:) https://drive.google.com/open?id=13NsidjowVUqKWaUgsU-qL4gFQaP1BENg
On my computer, Google Chrome shows you the source code for the file.. you need to save that link as an ".fods" file, then it will open in Calc. (LibreOffice Calc Format:) https://drive.google.com/open?id=1kAwo38wZzWXd11W8biVV13kSY8sCnNVX On my computer, Google Chrome wants to open this file with Google Sheets. But Sheets doesn't understand REGEX. Download it as an .ODS and it should open. ______ First name for cell A1 =REGEX(A1,"(.+) ([^ ]+$)","$1") (returns all but the last word, unless you have trailing spaces.) Last name for cell A1 ==REGEX(A1,"(.+) ([^ ]+$)","$2") (returns the last word, unless you have trailing spaces.) On Mon, Apr 20, 2020 at 7:39 PM Pat Brown <[email protected]> wrote: > I have a spreadsheet that includes a column consisting if people's names. I > want to split this into two columns. I want one column with the given names > and the other with their family names. This requires taking the last word > in the column and creating a new column with this word. Is there a way to > do this in Calc? > > Thanks, > > Paddy > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
