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.
No comments:
Post a Comment