Sort WBS Codes

  • Thread starter Thread starter John castle
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Text Fields as numbers 7
Replace Function help 3
Need Help w/ApplyFilter + Query 1
Delete first few cell characters 4
How do I retain formatting? 5
Text to Column and Transpose? 3
same query, same data, same machine, sometimes missing one row returned 8
Getting the Sort Order on a string with multiple "Periods" 6

Back
Top