How can I cut data from one column and move it to another.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of several thousand data points in a txt file. When I copy it
it all goes into one colume but does seperate by line. There are two seperate
data points in each line. I need to take the second point and move it into
the second column.

Example
1994 4.21 ( sperated by five spaces)
into this
1994 | 4.21 ( two different columns)

Is there a way I can tell Excel to skip 9 spaces and then cut the next four
to the next column?
 
Back
Top