advanced excel training - Splitting data from 1 cell to 2 cells

Emma

Not sure if it can be done automatically but you can do it in bulk. Select the column with your data in it, then go to the 'Data' menu and select 'Text to columns'. This will then start a wizard that will guide you through it. It gives you a graph showing your data and you simply move a line to where you want to break it up. It will then move everything to the right of that line into the next column. Make sure though that the column to the right is empty otherwise it will overwrite any data already in it.

Hope that helps

Tristan