You can use Text to Columns to do this. Go to Data - Text to Columns and
follow the instructions

James


"jv" wrote in message
...
I have a Column that is currently set up as follows:

jones john & sharon

I want to divide the column and make two colums like:

Column one = Jones
Column Two= & Sharon