View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default 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.