Re: [libreoffice-users] Splitting columns in Calc

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 <mistyhaven@gmail.com> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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