如何对包含数字和数字的Excel列进行排序 [英] how to sort excel collumn that contain number and number with text

问题描述

我有一个excel表格，其中包含一列，数据如下所示，并且单元格格式为常规:

I have an excel sheet that contains a column in which the data is as below, and the cell format is general:

1
2
12
1\a
1\b
3
3\a
4
5
6
6\a
7
8
9
10

如果我对此排序，则得到的结果为:

If I sort this I get the result as:

1
2
12
1\a
1\b
10
3
3\a
4
5
6
6\a
7
8
9

但是，我希望结果为:

However, I want the result as:

1
1\a
1\b
2
3
3\a
4
5
6
6\a
7
8
9
10
12

如果有任何想法，请帮助我. :)

If any one has any ideas, please help me. :)

推荐答案

格式化为文本

选择自定义排序

选择``对数字和分别作为文本填充的数字进行排序''

它可以在Excel 2007上运行.无法记住2003年的确切程序，但是如果不起作用，请告诉我.

Format as text

Select custom sort

Select ''Sort numbers and numbers stroed as text separately''

It works on Excel 2007. Cannot remember exact procedure on 2003 but if this does not work let me know

创建另一个具有= VALUE(第一列)的列并按此排序.只要您没有#a#，它就可以正常工作.

Create another column that has =VALUE(first column) and sort by that. This should work fine as long as you don''t have #a#.

这篇关于如何对包含数字和数字的Excel列进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！