Join Dennis Taylor for an in-depth discussion in this video Split data into columns with the Text to Columns feature, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] The common problem with data…that you get from other sources…is too much information in the same column.…Now, that's not always bad,…and we have to take this on a case by case basis.…But on this worksheet called Text to Columns,…we've got some names in column A.…Now, imagine this as part of a larger list…with other information off to the right of it.…In this example, you only see a single column.…But we cannot sort this list by last name…in its current state…because the names are in first name, last name order.…We could, however, split these into separate columns,…and then we could either rejoin them in reverse order,…or maybe just leave them in separate columns,…then we can sort our list by last name.…
So, Text to Columns usually begins with the idea…that we probably will need an extra column,…typically to the right.…In this case, we're going to split these names.…Notice that none of them have middle initials,…they're all single names and we don't have any Mary Jo's…or anything like that, multiple names,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes