splitting 1 column of data into multiple columns
 

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!

CiceroCF wrote:

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

--

Dave Peterson