随笔 - 232
文章 - 0
评论 - 26
阅读 -
38万
08 2017 档案
Excel中针对IP地址的排序方法
摘要：新建一个辅助排序列，用辅助列来扩展，辅助列公式如下： =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),"00...
阅读全文
