sort sheet with Turkish Characters

B

biriktiricix

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort sheet with Turkish Characters 1
Define alphabetic sequence to sort by 2
OFFICE XP (MS WORD 2002) DOCUMENT PROBLEM 1
Collating sequence: feature or bug? 3
Sort with a "" formula result 8
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Macro that sorts data with blanks at the bottom 1
Sort fields with 1.1-1, 1.1-10a, etc. 9

Top