Want to split data into columns in a Google Sheet? Try Data - Split text to columns
Ever receive a set of data in a Google Sheet and it is all in one column?
In order to separate the data into 2 columns try selecting the column > Data > Split Text to Columns and choose your separator (I chose space)
Embedded below is a GIF followed by a 36 second YouTube tutorial.
Take care,
Brad
In order to separate the data into 2 columns try selecting the column > Data > Split Text to Columns and choose your separator (I chose space)
Embedded below is a GIF followed by a 36 second YouTube tutorial.
Brad
Comments
Post a Comment