You can take the text in one column and split it into multiple columns using the Convert Text to Columns Wizard. To get started, open the Excel Sheet ... values to numbers, date values to dates ...