Unexpected order for a range sorted with non alpha-numeric characters
<p>I'm getting an unexpected result when I sort a list with Excel or with some VBA (<code>Range.Sort</code>). It seems that the hyphen is simply ignored when the text is sorted:</p>

<p><strong>List sorted with Excel</strong></p>

<pre><code>align-content
align-items
alignment-baseline    &lt;&lt; Should be after "align-self"
align-self
animation-delay
</code></pre>

<p><strong>The same list sorted with Libre Office</strong></p>

<pre><code>align-content
align-items
align-self
alignment-baseline
animation-delay
</code></pre>

<p>The documentation doesn't provide any information on this behavior:</p>

<p><a href="https://support.office.com/en-gb/article/Sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654?ui=en-US&amp;rs=en-GB&amp;ad=GB#__toc246836970" rel="nofollow">https://support.office.com/en-gb/article/Sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654?ui=en-US&amp;rs=en-GB&amp;ad=GB#__toc246836970</a></p>

<p><a href="https://msdn.microsoft.com/en-us/library/office/ff840646.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/ff840646.aspx</a></p>

<p>So is there any rule behind this behavior ?</p>

<p>Is there an option to sort the list the same way a human would do (as Libre Office does) ?</p>