How to Split Text in Excel 2007
In Excel, you have the options to merge cells together or split cells apart. If several sets of data enter into one cell, such as when you copy and paste data into Excel, then you can split the data into separate columns by using the "Text to Columns" feature. This saves time since you do not need to continually re-type the data that did not copy and paste appropriately.
Highlight the data you want to separate.
Click the "Data" tab at the top of the page, then "Text to Columns."
Select "Delimited." Click "Next."
Choose your delimiter, such as a space or comma. This is where Excel separates the data. Click "Next."
Select the "Column data format" that is appropriate for your data. Click "Next."
Select where you want the split data to go to and click "Finish."