Split column data using Text to Columns and Flash Fill

- [Instructor] When you work with lists of data,…often, you'll want to sort the list.…Now, this list on the worksheet called Split Data…in our Chapter 10 workbook file is not particularly large.…What would happen, though, if we wanted to rearrange this…by sorting based on last name?…Well, we can't really sort on last name,…because the way the names are entered,…it's first name, space, last name.…Now, again, not a monumental re-typing effort,…but that's not going to be the solution,…and sometimes, when you encounter large lists,…if you see names like this,…you've got a problem in that you can't sort by last name.…

And looking at column B, could we sort this list by state?…Could we sort it by ZIP code?…Not in its current form.…There are two major features for correcting…this kind of data.…They're both found in the Data tab.…One it called Text to Columns,…and part of the description there says…you can separate a column of full names…into separate first and last name columns.…Ideally, what we want to see instead of the data…