In a list of names, when I use Power Query to sort them alphabetically, it sorts names with apostrophes differently than Excel (or Word). I figured out that there are two versions of the apostrophe, and all of mine are CHAR(039) but the sort is reversed in Power Query. Below is a sample and the same in PowerQuery. Trying to avoid having to add another level of sorting as part of a merge of the queried data or complicate matter with index columns.

Apostrophe sort Excel.png
Apostrophe sort PQ.png

Seems a simple issue but it has been driving me nuts.
Thanks for any assistance.