Sort order in Excel

[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

 

[Stephen Bye]

How about
="ZZ"&CHAR(CODE("Z")+1)

 

[mjfritts]

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

 

[Charles Williams]

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

 

[mjfritts]

How did you know to use 142 for ZZZ

 

[Charles Williams]

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

 

[mjfritts]

Got it ... thanks

 

[Gord Dibben]

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

 

[Stephen Bye]

It's a caron.

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

 

[Gord Dibben]

Stephen

Thanks. caron or hacek it shall be.

Gord