05 2023 档案

把IP地址按照最后ip位的大小排序用wps怎么做？超级好用
摘要：在后面新建一个辅助列，输入公式：=TRIM(TEXT(LEFT(SUBSTITUTE(A1,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(A1,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITU 阅读全文
posted @ 2023-05-25 15:04 寻梦99 阅读(1122) 评论(0) 推荐(0) 编辑