Forum Discussion
Solved
Sorting small and capital letters correcly
I have a shared Excel-based database with some colleagues. One of the database attributes is the type of Schedule, which can be one of the A, a, C, c, G, g, S, s, etc. letters. When I attempt to sort...
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]
Thanks Rajesh_Sinha. I'd follow your approach if I were the sole user. With a shared database, I prefer not to add extra columns.
Using extra column is not a big issue if your data set is shareable even,,, Copy Sorted data and Paste as Link,,, other create Helper column at far from main data set columns,,, Another is VBA macro,,, without extra column,, are you comfortable with that ?