| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLO
That would be better asked in an MSWord newsgroup.
(I don't have any idea.) Maureen wrote: How about in Word? "Dave Peterson" wrote: 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 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
