✔ 最佳答案
假設你的example是放置在column A,
copy the formula"=INT(RIGHT(A1,LEN(A1)-1)") to B1, select and drag down to B5.
該公式會複製A列的值,並除去第一個字母。
然後你同時select column A & B, sort the 2 columns by column B.
完成后,你可以把 Column B 刪除
.....A.......B
1...a100..=INT(RIGHT(A1,LEN(A1)-1))
2...b200..=INT(RIGHT(A2,LEN(A2)-1))
3...c300..=INT(RIGHT(A3,LEN(A3)-1))
4...d400..=INT(RIGHT(A3,LEN(A4)-1))
5...e500..=INT(RIGHT(A3,LEN(A5)-1))
2015-03-09 17:54:29 補充:
Oops! 看不到原來知足常樂已在意見頁答了 :)