Excel Guides

Sorting Letters and Numbers in Excel

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:

  1. Select the cells that you want to sort.
  2. On the Data tab, in the Sort & Filter group, click Sort. The Sort dialog box appears.
  3. Under Column, in the Sort by box, click the column that you want to sort. Under Order, do one of the following:
  4. : 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).



    4. Under Sort Order, do one of the following:

              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).
           b. To sort by number value, click Custom List.
       c. In the Custom Lists box, do one of the following:
       1. If the list that you want appears in the Custom Lists box, select it.
      2. If the list that you want does not appear in the Custom Lists box, click NEW LIST.
    3. In the List Entries box, type your list entries, separating each entry with a comma.
    4. Click ADD.
    5. Click OK twice.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.