Split or join columnar data with Text to Columns or Flash Fill

- [Instructor] When you're dealing with names … and sometimes address lists like we're seeing … on this worksheet, sometimes you want to split … the information into separate columns. … Sometimes you want to join information … from different columns. … The two broad approaches we use in these situations … are found on the data tab in the ribbon. … One of them is called text to columns. … This is strictly for splitting information … into separate columns. … A newer feature, just to the right of this … and your icons might look a little different … on your screen, just to the right of that, … flash fill that allows us to either … split data into separate columns … or to join data from separate columns. … Let's first look at the data in column A. … Imagine that's a huge list with other … contact information to the right. … We can't sort the list by last name. … Now we can either split this information … into two separate columns, that would be helpful, … with different names, we could sort our list. …