Change single column into two columns

I often get names as a single column of data, and then need to separate the data into first and last names. This article describes the procedure for automating this problem.

LibreOffice

Open LibreOffice Calc.

1. Paste your list of names in Column A.
2. Select Column A.
3. Go to Data > Text to columns...
4. Make sure the Space separator is selected.
5. Click OK.

You list will now change from this:

To this:

Thanks for visiting.