Forum Discussion
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]
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]
Just passing by to let you know that I published a video with my answer to this question.
I thought the question was interesting and I hope it can help other people as well. 🙂
- Thank you Celia_Alves. These sound simple now.
if you end up using custom lists, since you mentioned multiple users, I believe the list must be added to each machine where the file is used. I think I forgot to mention this detail.
- Great! If my suggestion helped, please consider to click on "Mark as best response" under my answer. Thank you and good luck!
