excel - 如何对以逗号分隔的数字进行排序

Question

我想对具有逗号“，”的数字列表进行排序，作为千位分隔符，从大到小。我怎样才能做到这一点 ？有没有更好的方法是将邮箱使用率从大到小排序？

例子

Mailbox Usage                        Helper 
952.2 MB (998,459,360 bytes)         998,459,360 
950.9 MB (997,059,715 bytes)         997,059,715 
945.7 MB (991,650,962 bytes)         991,650,962 
92.85 GB (99,701,179,524 bytes)      99,701,179,524 
938.9 MB (984,498,622 bytes)         984,498,622 
936 MB (981,481,636 bytes)           981,481,636 
935.5 MB (980,976,385 bytes)         980,976,385 
94.19 MB (98,769,194 bytes)          98,769,194 
91.46 GB (98,204,797,816 bytes)      98,204,797,816 
91.02 GB (97,730,526,294 bytes)      97,730,526,294 
90.99 GB (97,701,587,415 bytes)      97,701,587,415 
919.3 MB (963,922,906 bytes)         963,922,906 
92.5 MB (96,988,172 bytes)           96,988,172 
92.34 MB (96,822,749 bytes)          96,822,749 
90.05 GB (96,687,167,126 bytes)      96,687,167,126 
89.85 GB (96,477,143,313 bytes)      96,477,143,313 
89.65 GB (96,259,776,951 bytes)      96,259,776,951 

标签： excelsorting

Answer 1

使用公式将文本转换为数字：

=VALUE(SUBSTITUTE(B2,",",""))

然后排序