Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Terminal-digit order

Posted by Kevin on September 04, 2001 9:05 AM

How do I place a long list of file numbers in terminal digit order using the last 6 digits; In other words, sort first by the last two digits (terminal), then by the two digits before the last two, then finally by the two digits before them.
55500000000
55500000001
55500000101
55500010101
55500100101
My guess is to start, you need three columns for the three sets of two digits. Thanks.

Re: Terminal-digit order

Posted by Mark W. on September 04, 2001 9:10 AM

Parse the values that you want to sort on to
separate columns using the Text to Columns...
menu command and then sort on the values in
the new columns.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.