ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort sheet with Turkish Characters (https://www.excelbanter.com/excel-discussion-misc-queries/256020-sort-sheet-turkish-characters.html)

biriktiricix

sort sheet with Turkish Characters
 
I want to sort a column which contains turkish characters. A sample sort
output is as follows:
ab
ça
ce
çg
ia
ıe
öa
oe

The correct form should be
ab
ce
ça
çg
ıe
ia
oe
öa
since ç comes after c, ı comes after i and ö comes after o.

Please help me how to achieve this result.

Thanks in advance

Talat Oncu

PS: Solution for Excel XP and Excel 2003 are welcome



All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com