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" <semofan@discussions.microsoft.com>
wrote in message
news:8ED04AA5-FCA5-4E5D-BBE0-938C09B20FCE@microsoft.com...
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):

> 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" <semofan@discussions.microsoft.com>
> wrote in message
> news:8ED04AA5-FCA5-4E5D-BBE0-938C09B20FCE@microsoft.com...
> 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. 
> 
> .
> 

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" <semofan@discussions.microsoft.com>
wrote in message
news:521D1C4D-F127-4435-A868-0F12F3CF4441@microsoft.com...
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" <semofan@discussions.microsoft.com>
> wrote in message
> news:8ED04AA5-FCA5-4E5D-BBE0-938C09B20FCE@microsoft.com...
> 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. 

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" <semofan@discussions.microsoft.com>
> wrote in message
> news:521D1C4D-F127-4435-A868-0F12F3CF4441@microsoft.com...
> 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" <semofan@discussions.microsoft.com>
> > wrote in message
> > news:8ED04AA5-FCA5-4E5D-BBE0-938C09B20FCE@microsoft.com...
> > 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. 
> 
> .
> 

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" <semofan@discussions.microsoft.com>
wrote in message
news:5EE55AC0-4600-4529-A3E6-7A881554CFF4@microsoft.com...
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" <semofan@discussions.microsoft.com>
> wrote in message
> news:521D1C4D-F127-4435-A868-0F12F3CF4441@microsoft.com...
> 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" <semofan@discussions.microsoft.com>
> > wrote in message
> > news:8ED04AA5-FCA5-4E5D-BBE0-938C09B20FCE@microsoft.com...
> > 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.
>
> .
> 

More information.
Microsoft sells a Slovak "language pack" for $25.00 at...
http://buy.trymicrosoftoffice.com/buyus/product.aspx?r=US_USD&family=langpack&culture=en-US
It might be worth a gamble for that amount of money.
'--
Jim Cone