How do I sort by EBCDIC sequence in EXCEL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a-d9a668078b22&dg=microsoft.public.excel.misc
 
gary_h said:
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.
Click to expand...


Referesh my memory - what's EBCDIC?
 
Referesh my memory - what's EBCDIC?
Click to expand...

... and old character coding system system IIRC :)

That said, I think ther are 2 obvious options :
1) Make up a 'custom sort list' in the order you want it and sort using that
2) use a helper column in much the same way.

HTH


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)
 
Hi Gary,

Aside to Doug -- EBCDIC a much more logical assignment of numbers and letters <grin>

It's a bit messy but you can create another column that you can sort on.
The problem is that ASCII is not really the collating sequence used in Excel
and it makes a difference if it is one more characters, but the main thing
is that letters will sort before digits. see
Sorting as if EBCDIC as on a mainframe (#ebcdic)
http://www.mvps.org/dmcritchie/excel/sorting.htm#ebcdic
 
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.
 
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.
Click to expand...

... and IIRC you can do "accurate" calculations (meaning rounding error
free) with it, as many calculators do. ?

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)
 
Back
Top