HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z
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.
|