Fab Friday: Google Sheet Magic- Splitting Your Text Part I
Have you found yourself with a list of data, and it is all in one column? Do you need it in two columns?
Highlight your column, and then go to Data- Split Your Text Into Columns.
Then it splits the text into columns. It will even ask if it separated it by the right separater. You can separate it by commas, spaces, periods, and more.
Stay tuned for Part II where you can take separated text and combine it into one column in your Google Sheet.
Comments
Post a Comment