i have to validate information daily from an excel sheet to a program. however the program sorts the information first alphabetically then numerically. excel sorts the opposite giving numeric priority over alphabetic. i need to be able to sort my alphanumeric numbers on excel the way the program is sorting it so the two lists look the same. here is an example of my information and the way excel sorts the info for me. is there a way to sort it giving a-z priority over 0-9?
001868223E73
00028A0E8E05
00028A45259A
00028A588F7A
00028A9DD5BC
00028AC45A6C
00028AC67CC2
00028ACD250C
00028AD58126
000A73F8F306
000E9B099C66
000E9B09BE90
000E9B0AC352
000E9B3427FE
000E9B3456E8
000E9BA63162
000F212B20A1
Bookmarks