Sort Excel Worksheet in Swedish Language Order

I just want to sort the data in one existing XL workbook (not in all of XL and not in all of Office 2010) using the Swedish language character set (I believe it's character set=ISO8859_1).  Compared to English, Swedish has two additional forms of A and one additional form of O, which sort at the end of the alphabet, not with the other forms of A and O. Excel (English (U.S>.)) ignores the diacriticals and sorts them as either A or O.
I don't want to change my keyboard, and I'm not particularly bothered by the proofing errors these letters create.

I've purchased the Swedish language pack, and opened the .exe file (OfficeLangPack_Swedish_x64.exe).  Unfortunately, the next thing I saw was a fairly long note in Swedish - which I don't understand beyond a few genealogy tems and some politenesses I learned as a child.  But there was an OK button, so I clicked on that.  After that - nothing.  Don't know if it installed or not.  I checked in Excel/options/language where it only shows English enabled and installed.  I tried adding Swedish there, and it comes up "not enabled" and "not installed".

So what do I need to do to get sorting in Swedish?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LangdansAuthor Commented:
Thanks BlueYonder,
Actually, I had tried a custom list, but such a list has to contain the full cell contents for the cells you want to sort - not just the letters in the words.  For example: H,M,L would not sort High, Medium, Low in the right order - you have to include the words "High", "Medium" and "Low" in the list.  To use a custom list, I would already have to have a sorted list of the things I want to sort.  One of these lists contains the names of 3362 Swedish parishes - a prohibitive manual sort project.
LangdansAuthor Commented:
More after poking around the internet to figure out if the language pack was actually installed, and if not - how to install it.  Several installation sites say language packs are only available for Win7 Ultimate or Enterprise.  There was no hint of this at the Microsoft help sites about language packs and language interface packs.  I have Win7 Professional.  So am I really out of luck on the language pack, or are these internet sites out of date?  I also found the language interface pack is not available in Swedish.
If language packs and language interface packs are not my answer, is there some way to tell excel to use the ISO8859_1 character set when it sorts?
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Cornelia YoderArtistCommented:
If this is a one-time thing that you will not have to do again, why don't you find a Swedish friend and email it to them to sort on a Swedish language computer and email it back to you.  I'm sure there are Swedish folks on EE who would do that for you.

assuming I would want to do the same, I would do the following (albeit I never had to do it):

Go to Control Panel and set your Regional settings to Swedish. Start Excel, or restart if you had it open...

This will in itself give you the correct sort order. It is not an Excel setting but a system setting. Windows will dictate how your Office apps deal with cell contents as much as it dictates other preferences according to your location settings.

If you want to add support to Excel for Swedish beyond that:

Go to your Start Menu > All Programs and browse to Microsoft Office>Microsoft Office Tools, and then select Microsoft Office(version) Language Settings.

Add Swedish to your selected languages.

Change the primary editing language to Swedish. Now you start Excel (or restart if you had it open) and the new unicode settings should apply.

As said I have not tried this nor do I have a Swedish text to try. But it seems the way to do this.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LangdansAuthor Commented:
Thanks capt.
Works like a charm.  And so simple.  No language packs, no LIPs.
Don't know how I would have figured this out without you.
And thanks to Yoder cm as well.  Unfortunately, the reason I need this capability is that I need to sort the lists different ways (by parish, county, surname, municipality, ...) depending on what I'm tying to discover.
Thanks much for the accept, I am glad I could help

best wishes
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.