新建一个辅助排序列，用辅助列来扩展，辅助列公式如下：
=TRIM(TEXT(LEFT(SUBSTITUTE(A1,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(A1,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITUTE(A1,".",REPT(" ",99)),200,100),"000")&TEXT(MID(SUBSTITUTE(A1,".",REPT(" ",99)),300,100),"000"))
以上方式转自网络，如有侵权情况请留言