The space isn't in the same position in each row.

JV

"James" wrote:

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