How to sort uppercase numbers in excel

php editor Xigua brings you a method of sorting uppercase numbers in excel. In excel, sorting uppercase numbers is not a simple operation, but it can be easily achieved with some techniques. This tutorial will introduce how to sort uppercase numbers in excel, allowing you to easily handle number sorting problems.

1. Open the form.

2. Select the cell range in column A, and click [Sort] under the [Sort and Filter] option under the [Data] function.

3. Click [Options].

4. Check the [Case Sensitive] option and click [OK].

5. Return to the [Sort] dialog box, check [Data contains titles], select [Case Sort] in [Main Keywords], and select [Sort by]. Value], [Sequence], select the [Ascending Order] option, and click [OK] after making the selection.

6. Return to the worksheet, you can see that column A is arranged in the order of [a, A, b, B——].

The above is the detailed content of How to sort uppercase numbers in excel. For more information, please follow other related articles on the PHP Chinese website!