Sorting small and capital letters correcly

Hi, SaeedShaeri 

here are two possible options of doing this without an extra column. I am using Excel for Microsoft 365.

The first option puts small case before the capital letters when sorting. See if this works for you:

Click anywhere on the table > File Tab > button Sort & Filter > Custom Sort > button Options > checkmark on "case sensitive" > OK.

[see pic 1 attached]

The other option is to use a Custom List.

First create the custom list by going to File > Options > Advanced

scroll down to General

click button "Edit Custom Lists..." > click where it says NEW LIST and add your list sorted the way you want.

Then go to Custom Sort again and under "Order" choose "Custom List":

[see pic 2 attached]