Google表格字符排序顺序

本文介绍了Google表格字符排序顺序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

当您使用过滤器对列表进行a-z排序时，在哪里可以找到Google使用的列表?图像为清晰起见:

更具体地说，我需要一个谨慎的角色；理想情况下为空白字符；在加号"+"之后排序.

解决方案

我已经进行了测试.您可能会在

我尝试了前3000个字符:

• A列:1到3000之间的数字
• B列:char公式: = CHAR(A2)

我使用过滤器对范围进行了排序，并得到了意外的结果:Google未使用 ASCII 对文本进行排序.

此外，请参见 sort 函数的功能与通过过滤器进行排序的方式相同.但是使用 query 进行排序会得到另一个结果.

当我在Excel中尝试相同的实验时，我感到更加困惑:

• = CHAR(A2)在Excel中给出另一个结果，而不是 ASCII char
• 字符的排序范围与Sheets结果不同.请自己尝试看看.

Is there anywhere where I can find the list google uses when you a-z sort a list with a filter? EDIT: Image for clarity:

More specifically, I need a character that is discreet; ideally a blank character; that is sorted after the plus sign '+'.

解决方案

I've made a test. You may see the result in Sample File:

I tried first 3000 chars:

• Column A: numbers from 1 to 3000
• Column B: char formula: =CHAR(A2)

I sorted the range with filter and got an unexpected result: Google is not using ASCII to sort text.

Also, see sort function works the same way as sort by a filter. But sorting with query gives another result.

When I tried the same experiment in Excel I was confused even more:

• =CHAR(A2) gives another result in Excel, it not an ASCII char
• sorting range of chars gives different from Sheets result. Please try it yourself to see.