| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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Ž 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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
