excuse me if this is not the right place to put my question over here, am just new!
however, the question is : you may have some weird problem such as the one am facing. the items are B7,B8C,B9B,B10A. i need to enter them as is. but when doing the ascending ordering the list appears up as the photo attached. logically B7 should be the fist B10A should be the last item.
be aware that i need to enter the item as it shown above, not adding ' 0 ' after ' B ' letter.
Regards,
Bookmarks