If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

alphabetize Greek language

This is marginally related to BibleWorks for some of the projects I'm working on, so I thought i'd toss it out there. Does anyone know how to make Excel alphabetize a Greek Unicode list using the Sort feature? Is this possible? I would think it would be since Modern Greeks must be able to use it to sort alphabetically too, but I have not yet figured out what I need to do to make that work.

helpful, but not quite there

Originally Posted by Adelphos

If you switch to a Greek keyboard within Windows the sort feature performs this properly.

I went into the control panel and changed the Regional languages, but I still find this problem happening: When I do sort in Excel it is sorting words which begin with vowels first by words which have accent marks before them so I have listed, then words with vowels and smooth breathing, then words with vowels and rough breathing, and then words that begin with beta, gamma delta, etc.

So the alphabetizing feature doesn't ignore (which I guess would be my preference) accents in its alphabetizing. Is that how you can get it to work too?

I don't think there's any way around this, at least not one I'm familiar with, as the sort feature will still recognize keystrokes in their ASCII order, I believe.

If you could find a way to easily remove/restore the accents and breathing marks, your problem would be solved, but that's a big "if" I think.

I will have to experiment, that's kind of a pain, but it might be the only way to go. I would have to make a quick macro to get rid of all accent marks/etc. Ultimately what I want to do is alphabetize raw Greek text. I guess I'll just copy the data I have in Column A to Column B, remove the accents and then alphabetize by column B.....