Mitsules, Mark
Mark.Mitsules at ngc.com
Tue Oct 21 08:58:38 CDT 2003
Greetings, I have a text field containing all possible 3 digit alpha-numeric combinations from 000 to ZZZ. I am looking for a method to sort this text field where 000 through 999 are listed in numerical order before the remaining alpha-numeric combinations are listed in ASCII sort order. Any suggestions? I have tried to do this in Excel, however, Excel makes some startling decisions on its own...such as turning 7E9 into 7000000000. Example: 000 001 . . 998 999 00A 00B . . ZZZ Mark Mitsules Senior Designer Department E13 Submarine Electrical Engineering Northrop Grumman Newport News 757.380.3376