摘要:
创建一个新的辅助排序列,并用辅助列展开它。辅助列的公式如下:=TRIM(TEXT(SUBSUBSITTE(A1,“000”)&;“000”)和;文本(MID(替换(A1100),“000”))从网络传输。如有侵权请留言
新建一个辅助排序列,用辅助列来扩展,辅助列公式如下:
=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"))
以上方式转自网络,如有侵权情况请留言