Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with inserting diacritics / special signs | Excel Discussion (Misc queries) | |||
How do I sort in Excel with sub bulleted text? | Excel Worksheet Functions | |||
How to sort column when cells contain both text & number (Sample X | Excel Worksheet Functions | |||
Sort cells with same text descending | Excel Discussion (Misc queries) | |||
Is there a way to sort text by frequency within Excel? | Excel Discussion (Misc queries) |