Sort text cells with diacritics in Excel

  • Thread starter Thread starter semofan
  • Start date Start date
S

semofan

Hello, I need to sort text cells with diacritics, like words with acute (Ã)
and carron (Č).
eg. I have words Acam, Ãcam, Acom, AÄom... and I need to sort them like
this: Acam, Acom, AÄom, Ãcam... Please help, thanks.
 
Why would AÄom come before Ãcam?
Is this type of sort a common need in your profession/industry/location?
Are you able to use VBA code (macro)?
--
Jim Cone
Portland, Oregon USA



"semofan" <[email protected]>
wrote in message
Hello, I need to sort text cells with diacritics, like words with acute (Ã)
and carron (Č).
eg. I have words Acam, Ãcam, Acom, AÄom... and I need to sort them like
this: Acam, Acom, AÄom, Ãcam... Please help, thanks.
 
To Jim Cone: Yes, exactly like you said, I need this type of sort in my job.
I have to sort different surnames and our alphabet (Slovak language) looks
like this: A, a, Ã, á, B, b, C, c, ÄŒ, Ä, D, d... So I have to sort
alphabetically the names at first by the 1st character in word, then by the
2nd character in word, etc.
eg. after the sort it would be: Acam, Acom, AÄom, Adam, Ãcam, ÃÄam, Ãdam,
ÃÄam, Boris, Brian, Broke, BÅ™ian, BÅ™uno, Cecil, ÄŒerný, David, ...
VBA code can be used , but I need instructions.
Michal Semelak

„Jim Cone" napísal (napísala):
 
Michal,

Windows XP has a Slovak language setting (control panel) and so does XL 2007 (options).
Using those settings, I would think, should enable a proper sort order. Have you tried them?
'--
Jim Cone
(Useful Excel downloads at http://excelusergroup.org/)




"semofan" <[email protected]>
wrote in message
To Jim Cone: Yes, exactly like you said, I need this type of sort in my job.
I have to sort different surnames and our alphabet (Slovak language) looks
like this: A, a, Ã, á, B, b, C, c, ÄŒ, Ä, D, d... So I have to sort
alphabetically the names at first by the 1st character in word, then by the
2nd character in word, etc.
eg. after the sort it would be: Acam, Acom, AÄom, Adam, Ãcam, ÃÄam, Ãdam,
ÃÄam, Boris, Brian, Broke, BÅ™ian, BÅ™uno, Cecil, ÄŒerný, David, ...
VBA code can be used , but I need instructions.
Michal Semelak



„Jim Cone" napísal (napísala):
 
Yes, I have Win7 and Office 07 both in Slovak language. I have to use my own
order to sort by using VBA.

„Jim Cone" napísal (napísala):
 
So are you saying that Excel 2007 does not sort correctly?
-or-
Are you saying that you want a specific custom sort order that is not in Slovak alphabetical order?
'--

Separate question: Is the following, that I put together, the correct character order for the Slovak alphabet?
(46 characters times 2; upper and lower case)

A
Ã
Ä
a
á
ä
B
b
C
Č
c
Ä
D
ÄŽ
DZ
DŽ
d
Ä
dz
dž
E
É
e
é
F
f
G
g
H
h
CH
ch
I
Ã
i
í
J
j
K
k
L
Ĺ
Ľ
l
ĺ
ľ
M
m
N
Ň
n
ň
O
Ó
Ô
o
ó
ô
P
p
Q
q
R
r
Å•
Å”
S
Å 
s
Å¡
T
Ť
t
Å¥
U
Ú
u
ú
V
v
W
w
X
x
Y
Ã
y
ý
Z
Ž
z
ž

'--





"semofan" <[email protected]>
wrote in message
Yes, I have Win7 and Office 07 both in Slovak language. I have to use my own
order to sort by using VBA.





„Jim Cone" napísal (napísala):
 
Back
Top