记录一个excel公式,把ascii字符串转为安码表数值排序的值

=SUMPRODUCT(CODE(MID(A1, ROW(INDIRECT("1:" & LEN(A1))), 1)) * 10^(LEN(A1) - ROW(INDIRECT("1:" & LEN(A1)))))

posted @ 2024-05-31 13:09  马肯尼煤牙巴骨  阅读(25)  评论(0编辑  收藏  举报