[摘要]：ip地址升序排列?答:ip地址升序排列方法。新建一个辅助排序列,用辅助列来扩展,辅助列公式: =TRIM(TEXT(LEFT(SUBSTITUTE(A1,".",REPT(" ",99)),100),"...
