A character or symbol which, when sorted in Excel, will be placed below the letter "z"

Hello,

Do any characters or symbols exist which, when sorted in Excel, will be placed below the letter "z"?

I entered each character from the keyboard (including the spacebar) into its own row in an Excel spreadsheet and then sorted the column (from A to Z) with the expectation that some characters would end up below the alphabet. However, none of them ended up below "z".

Next, I added a couple of characters from the symbol chart (¢ and ∞)* and even threw in a smiley face (☺) by pressing Alt+1. However, once again none of the characters or symbols was sorted to a position below "z" (see below).

Thanks

* The infinity symbol ended up after "9" but before "a" which was interesting but makes sense — and could come in handy on occasion.

Sorted list

'
-
 
!
"
#
$
%
&
(
)
*
,
.
/
:
;
?
@
[
\
]
^
_
`
{
|
}
~
¢
+
<
=
>

0
1
2
3
4
5
6
7
8
9

a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
WeThotUWasAToadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
This depends on the regional rules... We do have ž after z. You could also try ˙ (ALT+0255 on the numeric keyboard).

You may also look for other symbols in CHARMAP Windows application or you may simply test characters from ALT+0128 to ALT+0255.
0
Michael FowlerSolutions ConsultantCommented:
In en-US the characters Ž and ž will sort after Z

To test this for yourself

1/ Enter 1 to 255 in cells A1...A255
2/ Enter the formula =CHAR(A1) in cell B1 and then drag this formula down to cell B255
3/ Sort on column B
0
pcelbaCommented:
The ž character has code ALT+0158.

The blank cell is always sorted at the end.

Excel also allows sorting based on a custom sort list so you may create whatever sort order you need. More info: http://www.techrepublic.com/blog/10-things/10-steps-to-creating-a-custom-list-for-sorting-in-excel/

Or you may create a function and use it for sorting.
More about Excel sorting: http://dmcritchie.mvps.org/excel/sorting.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
psteffCommented:
When I need to do something like this, I usually do anywhere from two z's to five z's.  I know I won't have any legitimate names with any more z's than that.
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.