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),"000")&TEXT(MID(SUBSTITUTE(A1,".",REPT(" ",99)),300,100),"000"))

以上方式转自网络，如有侵权情况请留言