Hello--
I am new to this group and am not sure if this should be posted here or in the Excel Programming Forum. My question is as follows: I am creating a spreadsheet containing the name of Norwegian Lighthouses. I would like to be able to run a sort to put these in the proper order by the Norwegian alphabet. I have the Norwegian Proofing installed and enabled as the first language. The trouble is that the data is not sorting properly. Is there some trick that I can do to get this to work properly?

Couple ideas.

1. have the English spellings too and sort that way.
2. have a number ID field and manually number them how you would sort them.

Sorry. Not good answers.

If I were to have a column containing the data of "A1, A2, ... A10, A11, B1, B2, ... B10, etc." where the letter will represent the first letter of the lighthouse name, and the number after it would be where I want it sorted in order by. Is there a way that I can have the sort to have A10 to appear after A9 and B10, after B9, etc. instead of appearing after A1 and B1? Does this make any sense?

Sure. Rather than one column, use two. The first can be you letter designation. You can derive this automatically using a text function e.g. =left(A1,1). The next can be your serial designation e.g. 1,2,3,...99. Then sort using those two columns.

I would not have thought of doing it that way..Thank you very much for your help..I will try that and see if it does what I want.