From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Splitting data into multiple columns

Splitting data into multiple columns - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Splitting data into multiple columns

“

In this worksheet SplittingData, we've got our customer list, it's over 200 names and we'd like to be able to sort this list by the last name. But because the names are in first name-last name order in column A, we can't do that. This is a common problem, by the way. Also, if we want to sort our list by State, we cannot do that. Look at the entries in column D; City, State, Zipcode all together in one column. There are two methods for adjusting data here. One has been around for a while, it's a Text to Columns feature on the Data tab and a new one in Excel 2013 called Flash Fill will quickly allow us to readjust data as well. Let's focus on column D first, click column D. Before actually splitting this data into separate columns, make sure we've got some empty columns to the right and we do here. The command on the DATA tab is Text to Columns; Split a single column of text into multiple columns. Note how they do make reference here of separating a column of full names into separate…

Contents