Google表格字符排序顺序 [英] Google Sheets character sort order
问题描述
当您使用过滤器对列表进行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 anASCII
char- sorting range of chars gives different from Sheets result. Please try it yourself to see.
这篇关于Google表格字符排序顺序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!