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. We'll demonstrate how to do this using a date field in the NEISS small subset spreadsheet. A full date consists of three combined values, day, month, and year, which could all be broken out.
The Text to Columns function will take text in one column and split it up into multiple columns. Using the Reformatted Date column from the previous exercise, follow the steps listed here to put each data element in its own column.