Join Dennis Taylor for an in-depth discussion in this video Splitting data into multiple columns via Text to Columns, part of Cleaning Up Your Excel 2010 Data.
Splitting data into separate columns is an efficient way to not only change…the layout of data, but make it more suitable for sorting and use with functions and formulas.…I can't tell you how often I've seen data the way it appears here in column A.…With all good intentions, people enter names this way.…That's Eric Hendricks;…why wouldn't you type his name that way?…And many times people forget that they would later like to sort this data by last name.…Well, you can't do that with the names as they're displayed in column A. So a…common need is to split that data into multiple columns and either leave them…in multiple columns or put them back together so that it's last name, comma, space, first name.…
So as you look at the data in column A, do recognize that I am making the…example slightly simpler than it might be in real life, because I've omitted…middle names and middle initials.…We certainly, can based on the techniques you are going to see, accomplish the…objective of working with data like that.…
- Moving or inserting rows and columns of data with a simple drag
- Using Text to Columns
- Harnessing the Find and Replace command to replace data at the character level
- Dealing with special characters and wildcards during search
- Converting dates with text functions
- Converting text data to values/numbers
- Checking and correcting spelling mistakes
- Splitting data into multiple columns via the Text to Columns feature
- Combining data from different columns via concatenation
Skill Level Intermediate
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.