This one is quick and easy… and quite useful. If you have ever had a list of names or other data that needed to be split into separate columns, then you are in luck. For example: imagine having a roster of student full names and you wanted to make them separate columns.
Here is what you do. In Google Sheets….
- Take a spreadsheet with a list of names or other data in a single column.
- Highlight all the data.
- Then from the Data menu, select Split Text to Columns.
- A popup will appear allowing you to choose the separator. For this, example choose Space. But definitely play with the others too at some point!
- Your text will now be in two columns, separated at the space. One for First Name and one for Last Name.
Hope this helps!