When you have a list of data that contains both letters and numbers, you might want to sort the data so that the numbers come before the letters. Excel does not offer a built-in option to sort numbers before letters, but you can use a custom sort order to achieve this.
To sort numbers before letters in Excel, follow these steps:
: To sort in ascending order, click Ascending (A-Z). To sort in descending order, click Descending (Z-A).
: To sort by number value, click either Smallest to Largest (0-9) or Largest to Smallest (9-0). To sort by date or time value, click either Oldest to Newest (0-9) or Newest to Oldest (9-0).