From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Splitting data into multiple columns
From the course: Excel 2016 Essential Training
Splitting data into multiple columns
- In this worksheet called SplittingData, we're looking at two common problems that you might encounter when you're working with lists. Whoever prepared this list wasn't really thinking too much as the names were entered in column A, that later, we might want to sort this list by last name. And you can see how the names are put in, first name, last name. We cannot sort this list by last name in its current form. And also, depending on the size of the list and maybe it's quite large, we cannot sort this list by state. Nor can we sort it by zipcode based on the current arrangement. As a general rule but nobody's stopping you, don't put city, state and zip together in the same column. You can't sort by state, can't sort by zipcode. And with names, even though you might not be thinking about it initially, keep in mind eventually you will want to sort by last name. Now there are a couple of approaches to this. In this movie, we'll be talking about a feature called text to columns. It…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.