| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort by EBCDIC sequence in EXCEL?
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/comm...lic.excel.misc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
