Yes, you can sort numbers with letter suffixes in Microsoft Excel. Here's how:
- Select the column that contains the numbers with letter suffixes that you want to sort.
- Click on the Data tab in the ribbon at the top of the screen.
- Click on the Sort button in the Sort & Filter section of the ribbon.
- In the Sort dialog box, select the column that contains the numbers with letter suffixes in the Sort by dropdown menu.
- In the Sort On dropdown menu, select Values.
- In the Order dropdown menu, select Smallest to Largest.
- Click on the Add Level button to add a secondary sorting level.
- In the Sort by dropdown menu for the secondary sorting level, select the column that contains the letter suffixes.
- In the Order dropdown menu for the secondary sorting level, select A to Z if you want the letter suffixes to be sorted in alphabetical order.
- Click on the OK button to apply the sorting.
Now your numbers with letter suffixes should be sorted in the order you specified, with the letter suffixes sorted after the original numbers.