HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z

[Maureen]

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

 

[Dave Peterson]

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.

 

[Fred Smith]

You don't need to shout. We can hear you.

You will need to get your data into a form that Excel Sort understands. One
option would be to create a helper column that creates sortable cells. Depending
on what your data looks like, it could be a simple as inserting a Z in front of
all double letters.

 

[Maureen]

How about in Word?

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.

 

[Dave Peterson]

That would be better asked in an MSWord newsgroup.

(I don't have any idea.)