1. Start with the Excel file
2. Add in 3 new columns (D, E, and F)
3. Highlight column C and select “data / text to columns” from the menu
4. Select “fixed format” and then use the cursor to separate columns 1-2, 3-5, and 6-9
5. Finish

The result should look like this and allows a match/merge by State, County, and Township.