Sorting differences Mac vs PC

Colin_Williams 

All of the anomalies involve hyphens

But that doesn't really matter, the problem is that the two installations of Excel use different parameters for the Alphabetical sorting, so give different results. You would expect it to be consistent.

I agree with the expectation. At least, though, the anomalies are known to involve hyphens. So while we work to get Apple to agree with the rest of the world (I'm an Apple user myself), and returning to your original request for a way to overcome this discrepancy: to the extent you need a consistent result, you could create a second column (a helper column) in which all of those hyphens are removed (by a text formula) and use that helper column as the basis for your sort. {I have the impression you're entirely competent with what would be involved in writing such a formula.}