Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Preparing Data for Analysis!
You have completed Preparing Data for Analysis!
Preview
Clean the rest of the dataset using tools in Google Sheets.
Update
- "Trim Whitespace" in Google Sheets can now be found under
Data > Data Cleanup > Trim Whitespace
Resource
- Contains Text Custom Formula
=istext(B:B)
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
since Google Sheets has a helpful
built in feature for this, too.
0:00
Let's select all of the data and
go to Data > Trim whitespace.
0:02
And you can keep an eye
on this cell right here.
0:07
We have some whitespace at the beginning.
0:10
And if I click it,
you can see that whitespace is gone.
0:13
And it also tells you how many
cells it found whitespace for,
0:16
just in case you need that information,
but that's it, super easy.
0:20
Next, let's handle spelling mistakes.
0:25
We can use Google's built in feature for
this, too, Tools > Spelling > Spellcheck.
0:28
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up