最簡單的方法，最實用的方法，最可行的方法：用公式在對應的空列輸入以下公式：=IF((LEN(A1)-0)<=0,"",MID(A1,LEN(A1)-0,1))&IF((LEN(A1)-1)<=0,"",MID(A1,LEN(A1)-1,1))&IF((LEN(A1)-2)<=0,"",MID(A1,LEN(A1)-2,1))&IF((LEN(A1)-3)<=0,"",MID(A1,LEN(A1)-3,1))&IF((LEN(A1)-4)<=0,"",MID(A1,LEN(A1)-4,1))&IF((LEN(A1)-5)<=0,"",MID(A1,LEN(A1)-5,1))&IF((LEN(A1)-6)<=0,"",MID(A1,LEN(A1)-6,1))&IF((LEN(A1)-7)<=0,"",MID(A1,LEN(A1)-7,1))&IF((LEN(A1)-8)<=0,"",MID(A1,LEN(A1)-8,1))&IF((LEN(A1)-9)<=0,"",MID(A1,LEN(A1)-9,1))&IF((LEN(A1)-10)<=0,"",MID(A1,LEN(A1)-10,1))&IF((LEN(A1)-11)<=0,"",MID(A1,LEN(A1)-11,1))&IF((LEN(A1)-12)<=0,"",MID(A1,LEN(A1)-12,1))&IF((LEN(A1)-13)<=0,"",MID(A1,LEN(A1)-13,1))再向下填充下就以了，最多可支援13個字元的單詞，如果還多於13個，可以在公式後再加&IF((LEN(A1)-14)<=0,"",MID(A1,LEN(A1)-14,1))只是其中的減號後的數字更改成越來越大之後再按此結果排序。完成。。。。。公式是長了點，不過很簡單的