Sort WBS Codes

J

John castle

I have WBS codes exported from project, how do I sort so
that eg 1.8.3 comes before 1.8.10. Obviously text sorting
will put the 1.8.10 first.
 
K

kkknie

If you add some columns after the column with the WBS codes, you ca
select the WBS column and do a Text To Columns funtion from the dat
menu. Choose delimited and select a period as the delimitor. The
sort by the new columns. You can then delete these columns.

You may want to copy the WBS column first so you don't have to paste i
back together after the sort.
 
Top