Change single column into two columns

LibreOfficeI 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:

Fred Flintstone
Wilma Flintstone
Barney Rubble
Betty Rubble

To this:

Fred Flintstone
Wilma Flintstone
Barney Rubble
Betty Rubble

 

Thanks for visiting.