View Single Post
  #1   Report Post  
Jason
 
Posts: n/a
Default How do I split one cell of 6 numbers into two cells of 3 and 3?

I have a column of data that has six numbers in each cell, however I need to
split this into two columns, where the first column is the first three digits
and the second column is the last three. There is no separator (space, comma
or dash) between the numbers. Any suggestions?