splitting 1 column of data into multiple columns

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

Guest

I am trying to split up some data into multiple columns with part of the data
in each column... ie: 02-34-5-M is currently in one column... i need it
split into 4 columns as the following....
02 34 5 M
01 256 0 Q
7 45 4 T
This needs to be done so I can sort by using the 2nd set of numbers.
Thanks in advance for your help.
Carl
 
Select that column and do Data|Text to columns.

I'm not sure if you want the fields with numbers as Text or Numbers (General).

And make sure you have some empty columns to the right!
 
Back
Top