Saturday, July 7, 2018

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

No comments:

Post a Comment