View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
gary_h
 
Posts: n/a
Default How do I sort by EBCDIC sequence in EXCEL?

EBCDIC is an acronym for Extended Binary-Coded Decimal Interchange Code. It
is used mainly on mainframes. ASCII is used mainly on PC's. EBCDIC used
hexadecimal representation (i.e. 00 through FF). The letter A is C1, J is
D1, S is E2, zero is F0, space is 40, etc.
Gary H.

"Doug Kanter" wrote:


"gary_h" wrote in message
...
The only available sort sequences I can find in EXCEL are ASCII and some
customized DAY/DATE sorts. I would like to sort in EBCDIC sequence. I
tried
to make a customized sort list (i.e. A,B,C....X,Y,Z,1,2....8,9), but that
only seems to work on the first character within a cell. It returned P7
before PA on my sort.



Referesh my memory - what's EBCDIC?