On Tue, 21 Apr 2020 02:37:33 +0200 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? Note that the family name may not always be the last word. There are various cultures where the family name comes at a different position in the order, and even in English culture the family name may consist of more than one word. > 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
