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.
- Paste your list of names in Column A.
- Select Column A.
- Go to Data > Text to columns...
- Make sure the Space separator is selected.
- 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.