Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- Regards, Fred "Maureen" wrote in message ... HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF AFTER THE SINGLE A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort by column problems | Excel Worksheet Functions | |||
SORT A LIST OF NUMBERS AND LETTERS A,B,C,D AND FIND MAX | Excel Worksheet Functions | |||
How do I format a column in alpha order? | New Users to Excel | |||
need help righting script to sort rows alphabetically then seperate them to line up | Excel Worksheet Functions | |||
How do you sort words in Excel by the number of letters in a word | New Users to Excel |