"CiceroCF" wrote in message
...
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.
Currently, this is an Excel file.
Thanks in advance for your help.
Carl


Assuming 02-34-5-M is in A1, use

=LEFT(A1,2) -02
=MID(A1,4,2) -34
=MID(A1,7,1) -5
=RIGHT(A1,1) -M

/Fredrik