Join Dennis Taylor for an in-depth discussion in this video Adjust phone numbers and SS numbers for consistency, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] When you're trying…to match up different lists,…you sometimes run into problems…if you're trying to compare lists…based on either Social Security numbers of phone numbers.…And we need to clean up the data…in one of these two lists here,…because we're having problems with matching.…Now, in this worksheet, referred to as SS# and Phone,…we see in column A there are Social Security numbers.…And they're also over in column F.…Imagine these are different lists…and possibly they're on different worksheets,…but for easy of use, here,…we've put them on the same worksheet.…
And here's what we'd like to be able to do.…For the list on the right,…we'd like to pick up the employee's name…and put it in the list.…And we can see that there's a Social Security number…in the list on the right, in column F,…it's also in the list on the left, column A.…We don't necessarily know if every Social Security number…that's here is going to be found in the other list.…The list on the left is organized by employee name,…it's in alphabetical order.…
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