All four parts of the employee addresses (street address, city, state, and zip code) have been entered into a single column. While this may work for some purposes, it isn't ideal. With the data in one cell, it cannot be sorted, filtered, or otherwise analyzed by any of the individual elements. For example, you could not use this data to see how many employees live in Indiana or to create mailing labels sorted by zip code.
Google Sheets has an easy way to separate data into multiple columns.
If you are beginning this course at this point, you will need to copy the practice workbook to your Google Drive.
Right-Click Copy practice workbook, Click Open link in new window
The file begins to open in a new window of the web browser. Before the document will open and can be edited, we need to make a copy of it.
Move to the new browser window.
Click 
A copy of the file is now open and, by default, is saved in your Google Drive. The filename now has the words "Copy of" at the beginning.
Before beginning the process of splitting cell contents, you will want to ensure that there is no data in the cells to the right of the column to be split. Any data in those cells will be overwritten by the split data. The addresses are in column H and the columns to the right are all empty.
Click in cell H2
Control key + Shift key + Down Arrow key
With the appropriate data selected, we can now split the text into separate columns.
Click Data, Click Split text to columns
The four parts of the addresses are now in separate columns. The columns of newly separated data (City, State, and Zip Code) do not have column headings. Let's add those now.
Click in cell I1, type: City Tab key
State Tab key Zip Code Enter key
The new columns are all a bit too wide for the data they contain. We can resize all of the columns to their ideal width by selecting all of the columns and Double-Clicking between two of them.
Press & Drag from H to K
Double-Click between any of the selected column headers
The columns now fit the data they contain.
