Skip to Main Content

Data Cleaning with Excel

Through this guide you will learn tricks and tips to better clean and organize tabular data using Microsoft Excel.

Splitting Multi-Valued Cells: a Two Part Exercise Using Dates

A 'value' in a spreadsheet file is simply the contents of any given cell. A frequent need in data cleaning is to take a group of cells in which multiple values, or types of content, have been added, and break them out into new columns for each type of data. In the next two sections we'll demonstrate how to do this using a date field in the NEISS small subset spreadsheet.