excel中怎么将13-1-1,13-2-1,13-3-1,13-10-1,13-11-1,13-12-1进行排序呢?

题目

excel中怎么将13-1-1,13-2-1,13-3-1,13-10-1,13-11-1,13-12-1进行排序呢?
希望13-10-1,13-11-1等排在13-2-1的后面.
eg：现在有13-1-1,13-1-2,13-2-1,13-2-2,······直到13-10-1,13-10-2,13-11-1,13-11-2.将其进行排序,优先第一位数字,然后按照中间这个数字,最后按照末尾数字来排序.
若是13-1-1-1,13-1-1-2.,13-1-2-1,13-1-2-2······到13-1-10-1,13-1-10-2,13-1-11-1,13-1-11-2···又怎么排啊?

答案

b1=--substitute(a1,"-",""),下拉,选中ab两列以b列排序