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.

...
The "Text to Column" feature in Excel is a real time saver,

Procedure

Step

Highlight the data you want to separate.

Step

Click the "Data" tab at the top of the page, then "Text to Columns."

Step

Select "Delimited." Click "Next."

Step

Choose your delimiter, such as a space or comma. This is where Excel separates the data. Click "Next."

Step

Select the "Column data format" that is appropriate for your data. Click "Next."

Step

Select where you want the split data to go to and click "Finish."