![]() ![]() ![]() ![]() Let’s sort these alphanumeric values in ascending order. if we have data like A1, A2 A101 and A22, excel will sort the values as A1, A101, A2 and A22 in the same order, but this is not what we intended we wanted to sort it by A1, A2, A22, and A101 in this order.īelow is a sample data of values/alphanumeric values that have numbers at the end on which we will perform sort by ascending order to show the challenge that we talked about earlier. ![]() The challenge associated with sorting the values with numbers in end is they will be sorted on the basis first occurrence of number e.g. In this post we will see how we could sort values in excel with numbers in end or how to sort alphanumeric values that have numbers at the end. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |