Splitting Cells in Excel

• If you want to divide a single cell, locate and click the cell. If it is a range of cells to be divided, highlight them all (note, the range can be any number of cells, but the range must be contained within the same column). Alternatively, you can select an entire column to be divided by clicking the column letter.
• Ensure the cells to the right of the selected column, cell or range are blank – or they will be overwritten. Select the Data menu, and click Text to Columns.
• The Text to Columns Wizard is displayed. This will detect whether or not the source data is separated by spaces or commas, and then presents several options such as the ability to set field widths and column breaks.
  
  In Step 1, selecting Delimited will force Excel to separate the source data by commas or tabs, whereas Fixed Width will force it to look for spaces instead. CHOOSE DELIMITED FOR SPACES TOO!
  
  E.g. a cell containing “1,1,1,1” should be separated using Delimited, and “1 1 1 1” should be separated with Fixed Width.
  
  Click Next.
• In Step 2 of the Wizard, set the column breaks. A single left-click creates a column break, and double-clicking a break will delete it. You can also drag the column break markers, to increase or decrease width. Click Next.
• In Step 3, select a format for the column based on the type of data being separated (e.g. General, Text, Date). Click Finish.
• The data is extracted from the source column, cell or range of cells and split out over multiple cells.