Thursday, August 1, 2019

Google Sheets: Split Text to Columns



Have you ever copied a list of names and wanted to paste them into sheets, but need the first and last names to be in different cells? This happens a lot to me at the beginning of every year. Sheets has a feature that will allow you to split the text within a column.  To do this:

  •  paste the names into a column
  • highlight the column,
  • select data
  • split text to columns. 
 This will split the names or other data into different columns.  This works really well if you are copying a list from TAC!

No comments:

Post a Comment