software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc


quot;gary_hquot; gt; wrote in message
...
gt; The only available sort sequences I can find in EXCEL are ASCII and some
gt; customized DAY/DATE sorts. I would like to sort in EBCDIC sequence. I
gt; tried
gt; to make a customized sort list (i.e. A,B,C....X,Y,Z,1,2....8,9), but that
gt; only seems to work on the first character within a cell. It returned P7
gt; before PA on my sort.Referesh my memory - what's EBCDIC?
In article gt;, quot;Doug Kanterquot; gt; wrote:
gt;
gt;quot;gary_hquot; gt; wrote in message
...
gt;gt; The only available sort sequences I can find in EXCEL are ASCII and some
gt;gt; customized DAY/DATE sorts. I would like to sort in EBCDIC sequence. I
gt;gt; tried
gt;gt; to make a customized sort list (i.e. A,B,C....X,Y,Z,1,2....8,9), but that
gt;gt; only seems to work on the first character within a cell. It returned P7
gt;gt; before PA on my sort.

gt;Referesh my memory - what's EBCDIC?

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

HTHBruce

----------------------------------------
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 lt;gringt;

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)
www.mvps.org/dmcritchie/excel/sorting.htm#ebcdic
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
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.

quot;Doug Kanterquot; wrote:

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

In article gt;, =?Utf-8?B?Z2FyeV9o?= gt; wrote:
gt;EBCDIC is an acronym for Extended Binary-Coded Decimal Interchange Code. It
gt;is used mainly on mainframes. ASCII is used mainly on PC's. EBCDIC used
gt;hexadecimal representation (i.e. 00 through FF). The letter A is C1, J is
gt;D1, S is E2, zero is F0, space is 40, etc.

... and IIRC you can do quot;accuratequot; 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)