Tech Tip Tuesday: Split Text in Google Sheets

tech-tip-tuesday

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….

  1. Take a spreadsheet with a list of names or other data in a single column.
  2. Highlight all the data.
  3. Then from the Data menu, select Split Text to Columns.
  4. 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!
  5. Your text will now be in two columns, separated at the space. One for First Name and one for Last Name.

Hope this helps!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s