Home > Glossaries, Microsoft Excel > Excel: Case sensitive sorting all caps first, then all lowercase, works for Greek text

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):

A
B
C
D
E
F
G
….
a
b
c
d
e
f
g
….

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: