View Single Post
  #1   Report Post  
jv
 
Posts: n/a
Default Can I divide a column at the first "space" occurance

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