Log in

How to sort mixed numbers and text, hierarchy numbers in Excel

20 Feb 2023 7:00 AM | Steve Foster (Administrator)

Sorting text and numbers separately in Excel is as easy as ABC or 123 :) But re-arranging product IDs, SKU's and other values that have both letters and digits in them may cause problems. Excel's alphabetical sort cannot distinguish a numeric part of a string to handle it separately. If you want to have more control over how alphanumeric stings are sorted, look through the examples below.

Read Article

Powered by Wild Apricot Membership Software