把IP地址按照最后ip位的大小排序用wps怎么做？超级好用

在后面新建一个辅助列，输入公式：=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"))

posted @ 2023-05-25 15:04  寻梦99  阅读(962)  评论(0)  编辑  收藏  举报