If your data always consists of one character or two characters, you could add a
formula to an adjacent column:

=len(a1)
and drag down

Then sort using this column as your primary key and the original column as your
secondary key.

Maureen wrote:

HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.

--

Dave Peterson