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"
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):
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"
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.