Excel: Case sensitive sorting all caps first, then all lowercase, works for Greek text
This is a useful function if you want to maintain glossaries, i.e. fix the wrong capitalizations. If you have two columns and you want to sort the entries in say, column A, then you add this in the first cell of column C:
=(CODE(LEFT(A1))>90) + 0
Drag it all the way down.
Sort by column C.
Sort by column A.
Done. If you have Greek text, use this instead:
=(CODE(LEFT(A1))>217) + 0
The sorting will be like this (for English text):