EXCEL文字+數字怎設程式排序 EX:1CA9,2CA100,10CA8,11CA238,8CA215,5CA125,6CA7上述文字要依1CA...2CA--- 3CA...4CA...5CA...這種方式排序?
回答 (1)
2016-11-18 4:17 am
加個輔助欄
B1=VALUE(LEFT(A1,FIND("C",A1)-1))
B1=VALUE(LEFT(A1,FIND("C",A1)-1))
收錄日期: 2021-05-03 13:54:25
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20161117000523AAzFDfE