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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.
 
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.
 
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.
 
How about in Word?

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How fill cells with alpha series? 3
How to type each letter of the alphabet automatically in a specific color in Word? 0
How can I fill alphabetic series in excel 3
Automatic numbering with letters 5
Open File menu sort alphabetical. 6
Columns not sorting properly. 2
Data Sorting Problem 2
How to sort names in alphabetical ascending order? 7

Back
Top