How does alphanumeric sorting work?
Alphanumeric ordering is done using the current language sort order on the client machine as defined by the operating system (i.e. Windows). The user requests the sort by clicking on the column header. A grid must have column headings in order to be sorted by the user.
How do I sort alpha numeric in Excel?
To sort, highlight both columns and sort on B. If there can be other prefixes, say b-, c-, etc., similarly split off the text portion to another column. Then sort on the text column as the first sort column and the number column as the second. Everything you highlight will get sorted according to the sort columns.