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
 
Top