Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Sort text cells with diacritics in Excel

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default Sort text cells with diacritics in Excel

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Sort text cells with diacritics in Excel

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.

.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default Sort text cells with diacritics in Excel

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.


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Sort text cells with diacritics in Excel

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

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.


.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default Sort text cells with diacritics in Excel

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
ď
dz

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


.


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default Sort text cells with diacritics in Excel


More information.
Microsoft sells a Slovak "language pack" for $25.00 at...
http://buy.trymicrosoftoffice.com/bu...&culture=en-US
It might be worth a gamble for that amount of money.
'--
Jim Cone
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with inserting diacritics / special signs Alojz Excel Discussion (Misc queries) 7 February 17th 09 09:20 PM
How do I sort in Excel with sub bulleted text? Jerome Excel Worksheet Functions 1 February 23rd 07 03:25 PM
How to sort column when cells contain both text & number (Sample X Hreinn Excel Worksheet Functions 6 December 12th 06 07:42 PM
Sort cells with same text descending T-DHM Excel Discussion (Misc queries) 1 January 6th 06 11:20 PM
Is there a way to sort text by frequency within Excel? jellis1919 Excel Discussion (Misc queries) 1 August 12th 05 02:40 AM


All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"