Calculation for specific text order & format

[ShannonM]

Ok, I have yet another calculation that is stumping me.

I have a checkbox set of provinces. I have created a calculation field (with the help of the some wonderful people here) that outputs the selected provinces with a specific format, in an alphabetically ordered list separated by commas.

So - for a record with Ontario, Quebec, and Manitoba selected - the calculation field for the desired output would be "Canada (Manitoba, Ontario, Quebec)."

Now, I need to create a new calculation field which will take "Ontario" (when it is selected) and remove it from the list and put it at the end. To clarify, the desired output would be:

"Canada (Manitoba, Quebec), Ontario".

I have spent a good day or more trying to come up with a solution but nothing seems to be working properly.

Any help would be greatly appreciated!

[ShannonM]

No takers?