Join Dennis Taylor for an in-depth discussion in this video Solution: Reorder names in an employee list, part of The 5-Day Excel Challenge.
- View Offline
(twinkling sound)…- The first objective in our Day 2 Challenge is to sort…the list in column A so that they're in order by last name.…However, the names as we see them…are first name, last name.…In order to solve this we need to…break up the names into separate columns…and then rejoin them.…In the first solution I'm going to show you here, is one…that will work in Excel 2013, 2010, and in prior versions.…What we need to do at first is to insert some new columns.…
I'm going to drag across columns B and C,…and then with the right mouse button, Insert.…These are temporary columns which we will get rid of.…The feature we need to use here after selecting column A…is found on the Data tab in the ribbon.…It's called Text to Columns.…The text that pops up is rather lengthy,…but it begins with, "Split a single column…of text into multiple columns."…All the names in the list of column A…are two names, first name, last name.…So we allowed some additional columns just in case.…
Column A is highlighted as we click Text to Columns.…
The challenges will ask you to:
- Generate a list of future dates
- Clean up a list of employee data
- Create a dynamic chart
- Create a pivot table to analyze sales data
- Match data across multiple lists
Starter and solution files for Excel 2010, 2013, 365, and Excel for Mac 2011 are provided in the exercise files, so you can follow along with your version of Excel.