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?
|