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
Come for the tech tips - stay for the Dad jokes! ����
Follow this Blog
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
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
Subscribe to:
Post Comments (Atom)
-
How to Respond to Texts with Emoji Reactions in iOS 18 With the release of iOS 18, Apple has introduced several ne...
-
Ever have a video playing on your mobile device and still want to scroll though your feed? Look in the upper right of your screen and select...
No comments:
Post a Comment