Sort order in Excel

  • Thread starter Thread starter mjfritts
  • Start date Start date
M

mjfritts

I am trying to come up with a 3 digit string of characters that wil
appear last no matter what in a alphabetical sort following ZZZ -- I a
unable to find a string that will work!

Please help
 
I just tested it in Excel and I think that it will still place my ZZ
records last and put your suggested string before it -- I will b
importing various records into Access with this designated 3 digi
string so it also needs to present ok also
 
This is not straightforward as it can depend on your language locale,
windows code page etc, and also Access will not neccessarily sort in the
same sequence as Excel:
but I would suggest trying =Char(142) & char(142) & char(142)

regards
Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com
 
char(142) is not actually Z , its Z with an accent I cannot remember the
name of.

in column a put numbers 1 to 255.
in column b put =Char(a1) and copy down.
This shows you all the characters

To find the sort sequence: copy column B and do a pastespecial values, then
Sort it, but be warned that the sort sequence you get is dependent on the
national language you are using.


regards
Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com
 
Insert>Symbol and browse around for the symbol.

Note: it is not ZZZ, but ZZZ with a "v" thingy on top of each Z.

Now what we need is a name for the thingy<g>

Gord Dibben Excel MVP
 
It's a caron.

Gord Dibben said:
Insert>Symbol and browse around for the symbol.

Note: it is not ZZZ, but ZZZ with a "v" thingy on top of each Z.

Now what we need is a name for the thingy<g>

Gord Dibben Excel MVP
Click to expand...
 
Back
Top